Problem in Linking Excel files in Access

[karthik28]

I tried linking an excel spreadsheet to an access database. It shows me a window with the data but the header row in missing. However, when I open the excel file, save it without making any changes and try linking it again, it works fine.

Please suggest a solution so that I dont have keep saving the excel file before linking it.

Thanks

KS

[nico5038]

When linking an excel file using the wizard, this will have on the second window a checkbox "First row contains fieldnames". When checked the content will "disappear" and be used as the fieldnames in the table.

Nic;o)