Access Query Export - Append to Excel

[darinmc]

Hi
I have a query and am using the below

Dim StrFileName, StrFile
StrFileName = "TEST100"
StrFile = "\\Lynxserver\lynx\Payroll\NewEmployeesSAGE\" & StrFileName & ".csv"
DoCmd.TransferText acExportDelim, , "SAGE UnionTEST", StrFile, False

The csv file always has the same name

How do I get the data to append to the exisiting data or do I need to do something else?

Thx
Darin

 

[PHV]

A common way is to import into a temporary table and then append validated data in the permanent table(s).

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886