Append csv or xls file to existing table

  • Thread starter Thread starter RitchieJHicks
  • Start date Start date
R

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.
 
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.
 
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.
Click to expand...

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.
 
Back
Top