Importing Excelfile without headers gives error.

  • Thread starter Thread starter MarMo
  • Start date Start date
M

MarMo

Hi ,
I need to import daily Excelfiles into a table , but the Excelfile has
no headers. Even the first row is empty and some cells on row 2 are
merged.
example:
column
row A B C
D E
1
2 CompName 11/08/2009 (merged B+C)
3
4 Address City Postal
DrNbr Quantity
5
6 Highstreet Brussels 1000
1 3
7 Downstreet Brussels 1000
1 2
8

I first created a table with the import wizard. This gives me a table
with fieldnames like "Field1","Field2", etc..
If i want to import a second file with TRANSFERSPREADSHEET into the
table i get an errormessage 2391
Field 'F1' doesn't exist in the destination table.......

Is there a way to import an Excelfile or Exceldata into a table
without having an error and without modifying the Excelfile first.
I'm hoping someone can point me into the right direction.

Hopefully i explained it correctly.
Thanks
Mario
 
Hi Alex ,

I'll have a try , but i'm not familiar with making temp tables.
Is this like a tabledef ??

I'll give it a try , but i'll probably will be back here.

Thanks
Mario
 
When you use the TransferSpreadsheet method, just give in the name of your
"temp" table. I generally use something like "zz_Excel_Import"
 
Back
Top