470,810 Members | 1,007 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,810 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.


Oct 24 '07 #1
1 1167
3,080 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.

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 mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.