Discussion Locked

DataType greyed-Excel 97 to Access 97

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We're trying to import an Excel 97 file into a new table in a blank Access 97 database. During the import process, there is the window that allows you to choose the data type. It's greyed out but has Double in the field. We want it to be text or a simple number. Even if we change the type in Excel, it still displays as a scientific number in Access and won't let us control the data type. Any ideas???

5 replies

by dklippert

Access examines the first 15 rows of each column to make its best "guess" at the data type.
Once it guesses, you are stuck.
Either change the data in the first few rows, or export and import as a CSV file.

by dana803

We retyped the file, and it worked. I supposed we could have also just copied the data to a blank spreadsheet, too, to cut off any macros elsewhere in the spreadsheet that might have been there.......

by sl-campbell

Why not let it import as it wants, and once imported, change the field type to text?
If you want to append records you could also import to a temporary table(give it a temp name), and then change the field type, and create then an append query. Theprocess can be automated as well.

by dana803

I still couldn't change the data type after importing it. We ended up recreating the excel file, and it let us import it the way we wanted to.

This discussion is closed to new replies.