Linked Spreadsheet shows different in ACCESS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel 2003 spreadheet. The 1st three rows are headers. I can do a
link in Access of this spreadsheet but when I open it from Access instead of
seeing the header rows I see #num! in the header row as well as within the
data cells where I had no numberical number, just a dash.

I thought the linked Excel spreadsheet just opens up as is, with no
formatting issues.

Please advise
 
Access does not know you are using three rows as header. That is controlled
in your Excel page setup. Access can only use the first row as field names.

Try editing your first row to include the data from the other rows and
separating by using ALT-ENTER to set new line in the same cell.
 
Open the spreadsheet and create a named range for the data area. Then use
that range when linking.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Displaying zeros in cells 2
Linked Excel spreadsheet to be used as table 3
Excel Access - importing an excel spreadsheet 0
Linking to Excel spreadsheet 2
Copy Excel Data to Access 1
Linking from Excel 2003 to Access 2003 3

Back
Top