Formatting issues from excel to access

J

Jim/Chris

I have found when importing from Excel the first record
determines the formatting. Place a dummy record as the
first record with the integers(no decimal places) in the
fields that you want defined as numeric.

Jim
 
J

Joe Fallon

That is a good trick.
FYI it is the data in the first 16 rows that is examined to "guess" the data
type.
(In .Net it was the first 8 rows though! - they said 16 but it didn't work!)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
Decimal Truncation Issue upon Import - Access 2007 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Keeping Format Importing From Excel 8
error message importing excel 2
ACC2007: numeric fields truncated when imported from dBase III fil 1
Importing Text Fields in Excel 2
TransferSpreadsheet format question 5

Top