Formatting issues from excel to access

  • Thread starter Thread starter Jim/Chris
  • Start date Start date
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
 
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!)
 
Back
Top