Invalid Number Fields in Imported File

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
 
B

Brendan Reynolds

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.
 

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

Docmd.TransferSpreadsheet imports text fields in wrong format 1
Can't eliminate type conversion errors 2
Mixed Data Import from Excel 2
Numeric Field Overflow 2
Exporting Fields 1
Numeric field Overflow 1
URGENT: non-numeric values in "number" fields 6
An error occurred trying to import file 'c:\temp\import.txt'. The file was not imported. 0

Top