Invalid Number Fields in Imported File

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using MS Access 97 and importing a .txt file containing about 8 columns.

All of the columns are initially loaded as text. I'm wanting to change the
amount column from text to numbers. When I do this, Access tells me there
are 6 fields with invalid numeric data.

This column should contain only numeric data as I've removed any text data.

What's the best way to determine which fields are causing the invalid
numeric data?

Thanks,
Ed
 
SELECT TestText FROM tblTest2 WHERE IsNumeric([TestText]) = False

.... where 'TestText' is the name of your existing text column and 'tblTest2'
is the name of your table.
 
Back
Top