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

Oct 24 '07 #1

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)

Oct 24 '07 #2