Software

Ask something
Discussion Locked

Linking Excel Tables in Access

0 helpful
2 replies

by suzanneg

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am working with a client who is linking Excel tables in an Access database. No matter how we format the data in Excel, the data types seem to be corrupted when viewed in Access. Phone numbers, zip codes and dates may come over with #Num or other errors. I have tried formatting each field correctly, and formatting the zip field as text. (some zips are 5 digits and some contain zip + 4) There are always errors. Any ideas?

2 replies

by grl

If not, would you be able to email a small subset of the data to glehrer@thegrid.net? I'd like to take a look at this. Thanks.

by modelsolution

Build a table in Access, formatting each field appropriately. Enter data into the fields for one record to check the formats. Export the table to Excel, remove the test data and replace with your live data using Copy, Paste Special, Values. In Access link to this new Excel file.

Hope this helps.

This discussion is closed to new replies.