Excel Linked Table

G

Guest

I linked Excel table and am having an issue with one of the field format
conversion as follows:

The field in question is an alpha numeric ID field/column in Excel with some
all number, all text and combined number and text cells formatted as General
i.e MLE, 4523, S8T1 etc...When you open the linked spreadsheet in a direct
linked table this field shows records with the error #NUM! possibly because
during the field conversion Access assumes that it's a number field dropping
the all text. I tried converting the entire column to text in Excel and now
it gives me an error on the all number fields.

MLE
#NUM!
SSM
#NUM!

I don't see any other format in Excel that would accomodate this
circumstance. Please help...thank you.
 
G

Guest

Yep! I get around it by entering a row of false data just below the
headings so that it will bring the column-field in as text. Another way is
to build the table in Access first.
 

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

Excel linked to Access 1
Data Type Issue in Linked Excel Table 7
Field Data Type for Linked Tables 8
Linked Excel File 4
Changing field definition in Linked Excel Table 2
Linked Excel table with zip code data type error 5
#Num Error Linked Excel Table 1
type conversion error 1

Top