467,077 Members | 951 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,077 developers. It's quick & easy.

Problem in Linking Excel files in Access

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
  • viewed: 1058
Share:
1 Reply
nico5038
Expert 2GB
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

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Mark T. | last post: by
9 posts views Thread by mooseshoes | last post: by
reply views Thread by hivdb2@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.