Rodeo Clown
New member
- Local time
- Today, 18:29
- Joined
- May 27, 2024
- Messages
- 14
On to the next project. I have a text file that was exported out from our county's assessment office database. It includes all of the properties in the county. I imported this file into Excel and have a spreadsheet with nearly 300,000 rows. Each property has an identifier called ParcelNum and is comprised primarily of numbers, but may include a letter or two. So, that column is formatted as text in Excel.
When I try to import that file via the import wizard, Access changes the format of the ParcelNum to scientific notation. For example, ParcelNum 1000002000000 imports as 1.000002e+12.
Here is a screenshot of the spreadsheet:
and here is the input screen in Access:
Attached is a stripped-down spreadsheet and a sample access database. Yes, I know that the table is not normalized so don't chastise me for that. I'll fix that at a later date once I get this import function working correctly.
How do I get Access to import this field without changing it?
ps: seems like I can't upload an xlsx file, so I changed the filename extension to txt. Change it back if you want to open it in Excel.
When I try to import that file via the import wizard, Access changes the format of the ParcelNum to scientific notation. For example, ParcelNum 1000002000000 imports as 1.000002e+12.
Here is a screenshot of the spreadsheet:
and here is the input screen in Access:
Attached is a stripped-down spreadsheet and a sample access database. Yes, I know that the table is not normalized so don't chastise me for that. I'll fix that at a later date once I get this import function working correctly.
How do I get Access to import this field without changing it?
ps: seems like I can't upload an xlsx file, so I changed the filename extension to txt. Change it back if you want to open it in Excel.