Access 2000

  • Thread starter Thread starter tina
  • Start date Start date
T

tina

-----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
Click to expand...
called "errors"). All the other
fields 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
Click to expand...
displayed. since you built a form for the users to view
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).
 
tina said:
formatting doesn't affect the data itself, only how it is
displayed. since you built a form for the users to view
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).
Click to expand...

Hi Tina,

Thanks for replying. I'm obviously being overly ambitious as Tables, Forms,
Linking and Importing have got me all confused.
I want to import data from logfiles that are updated in realtime. I presumed
I would simply create a Table Template into which I could import my external
CSV data. However, the documentation led me to creating a Linked Table, but
I think that may be where I've gone wrong. [Please note, Access couldn't
intially import the date field which is in the format of mmm/d/yyyy.
Creating a custom-format Table field cured this little hiccup, all went well
and I successfully designed a Form].
I am totally satisfied with these results so far.

The problem I do have seems to be with the Linked Table. It only "links" to
a named logfile and I want to change this focus each week to a different
file (same data structure) because a new logfile is created every Sunday. My
attempts to change this focus does work EXCEPT for the date field - it gives
a "Conversion Type Error". If I then open the table in Design View, I get
one warning stating "Some Properties cannot be modified in Linked Tables"
and another in red text "This Property cannot be modified in Linked Tables"
so I am unable to either check the custom date format exists or change it if
it doesn't.
 
Back
Top