Importing Excelfile without headers gives error.

[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

 

[Alex Dybenko]

Hi,
I think you can import your excel file into new table, and then run append
query to copy data to destination table. and then delete this temp table

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[MarMo]

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

 

[Dale Fye]

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