Importing text file using spec into existing table..same as append

  • Thread starter Thread starter Cheese_whiz
  • Start date Start date
C

Cheese_whiz

Hi all,

If I import a text file using DoCmd.transferText, include a table name and a
specification, and the table already exists, it appears to just append the
records to the existing table.

Can someone confirm that as being the expected behavior? I'm using a delete
query to remove the old records but having the table persist allows the
relationships and primary key to remain intact without me having to address
them in code.

Thanks,
CW
 
In a word, Yes.

Of course you could test it out by checking the before and after data in the
table.
 
Thanks for the response, Jerry.

I was mainly just looking for some confirmation. I did test it, but I only
had one set of txt files to test it with, so I wasn't 100% comfortable
relying on those limited results.

Anyway, thanks again.
CW
 
Back
Top