Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import Table error - Type Conversion Error

Status
Not open for further replies.

mel41g

Technical User
Jan 31, 2005
7
VE
I need to import a Drivers License Number field from an Excel worksheet to an access table. Then field contains letters and numbers, and has no specific format, as different states have different formats. The largest entry is 14 characters long. How do I change the format so that Access will accept all of the records?
 
make driver license number field a text field in the table design. If you are importing this directly from an excel spreadsheet to a new table, you will need to make sure that the first value in this field contains some kind of text so that Access will automatically assign it as a text field.

HTH

Leslie
 
If I change the cell format in Excel to text, or if Access auto picks up text format, it changes the records that are all numbers into exponential numbers.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top