Importing csv file automatically

[MadRueNRG]

Hello all,

I have read some posts about importing a csv file automatically using a macro. I have tried this with set up Specs.
My database has a table that has been imported manually with the correct settings such as no duplicates on the first column.
If I was to import an update version of the csv file, I would then select to put it into an existing table, the one that I set up from the original csv file. This would then give me a message saying that some data might be lost. I click yes to this because it doesnt actually loose any data and works out fine.
How would I go about automatically importing this csv file so that it went into an existing table?

I am using MS Access 2003 Pro but it is saved as MS Access 2000.

Thank-you for your help,

Regards,


Rue

 

[spacepro]

You can use the transferspreadsheet function. Do a search for
'Transferspreadsheet'. here is a link for that search with the keywords.

Search for transferspreadsheet

Andy

 

[MarcusAntonius]

How do you get it to just update the records rather than append using Rue's method? (I get the message 0 records were deleted and 3000 were lost due to key violations)

 

[Treason]

Dump the csv into a new table.. then use an update query