Append csv or xls file to existing table

[RitchieJHicks]

I have an existing table with multiple fields/columns (lets call it Table1).

I want to import a csv (or xls) file sent from a client and append it to the
fields in Table1. However, te csv file has no headers and not all the fields
that my table has.

What is the easiest way to do this? The client will be sending the file on a
daily basis.

 

[Scott Lichtenberg]

Ritchie

I think the easiest way would be to import the CSV into its own table, then
use an append query or code to move the records into your main table.

 

[pietlinden]

I have an existing table with multiple fields/columns (lets call it Table1).

I want to import a csv (or xls) file sent from a client and append it to the
fields in Table1. However, te csv file has no headers and not all the fields
that my table has.

What is the easiest way to do this? The client will be sending the file on a
daily basis.

If the csv/xls file always has the data in a fixed order, then you can
create an import specification where you manually match the columns in
the csv file to fields in your table. Then you can reuse that import
specification when you do the import with TransferText or
TransferSpreadsheet.

 

[RitchieJHicks]

Thank you - I did this - it works a treat.