T
tina
called "errors"). All the other-----Original Message-----
I would like to automate the linking or importing of data from weekly
created CSV files (*2003071.txt,*2003072.txt,*2003074.txt etc).
Following several begginers guides, how-to's and online help files, I've
created a (linked) table with the relevant fields (inluding a necessary
custom date format mmm/d/yyy) and designed a form for easier viewing of the
data.
Each week, a new file is created and it's here that my troubles begin. If I
try "Get External Data/link" to this new file, I find my custom date format
isn't carried through.
In the "Advanced" section of the "Get External Data/link" wizard I tried
manually re-inserting the custom date format field as well as selecting to
use the "specs" of the known working table to no avail. I've also tried "Get
External Data/import" and the same thing happens (this time reporting the
errors both onscreen and in a detailed filed
displayed. since you built a form for the users to viewfields are fine, it's just this date field that won't behave.
Can anyone please explain the correct procedure to re-use the tables and
forms so I only have to create them once? Thanks.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.500 / Virus Database: 298 - Release Date: 10/07/2003
.
formatting doesn't affect the data itself, only how it is
the data, suggest you set the form's date control format
property to suit your needs.
if the form will not display the dates per your format
setting, suggest you check the linked table in design view
to see if the date field's data type is actually
Date/Time, or something else (like Text).