Discussion Locked
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.
by dana803
This question was closed by the author
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies
0 helpful
20 replies
Discussion
Is There any Reverse Video Search Tool
0 helpful
8 replies