Trying to impot Excel file into a table
I have an Excel file that has a column of number that look like this:
1.0000
2.0000
And I'm trying to import them into a table but no matter what format I set that field up in the Access table it ends up looking like:
1
2
I need to import and show the decimals. What am I doing wrong?
1.0000
2.0000
And I'm trying to import them into a table but no matter what format I set that field up in the Access table it ends up looking like:
1
2
I need to import and show the decimals. What am I doing wrong?
Last Comment
Brian Pringle
What data type did you declare in the table for that field?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Perfect.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
