Best Way to Import Data?

[Guest]

Hi there,

I have a large table of date events in an access database. I recieve daily
(workdays only) updates to the table which i FTP from an external website and
recive the files in CSV format. These downloaded files are named according to
the date thy apply to (ie yyyymmdd_filename.csv).

I am looking for the best way to automate importing this data. There are
multiple users and the data that i recieve may also be updated in the day (ie
new fTp file) so i need to ensure that for any data i import runs a delete
query first for that specific date.

So far i am thinking of the below:
write some code so that after receiving the file it gets re formatted etc
and saved as an excel file with a filename that doesnt include date (i can
write this)
Linking the database to this table and running delette/append queries to
import the data into my table.
Am i on the write track? the problems i see is then ensuring that it has
been the correct date imported?

I am looking more for advice than direct answers, so anything greatly
apprciated!!

 

[Guest]

you can import your file with just a few lines of code.

The transfertext method will bring your data straight into a table in
Access. Walk through the import steps manually first and build an import
specification which you can call from the transfertext method. Bring your
data into a temporary table and then use and update or append query to move
your new data into the main table you are using. Read transfertext method
help and/or build your code by building a macro and then saving it as a
function.