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

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
 
J

Jerry Whittle

In a word, Yes.

Of course you could test it out by checking the before and after data in the
table.
 
C

Cheese_whiz

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Type Conversion Failure importing number as text 1
Import errors importing Text into existing table, header vs no hea 3
import csv conversion & import spec error 1
Append csv or xls file to existing table 3
Importing PDFs 2
Text Import Problem 3
how to create an import spec 1
Best way to import text file into existing table on a daily basis 15

Top