Convert text to numbers

[randolphoralph]

I have a .CSV file that I imported into a database and includes 900,000 records. When I import the file I have to import all fields as text otherwise I receive errors importing.



One of the fields is Days and contains negative and positive numbers. I am needing to convert this field from text to number datatype. I have tried to change the datatype in the table and get a error message stating "Access can not change the datatype there is not enough disk space or memory". I believe this is due to the amount of records I have in the table.

I need to find another way to change this datatype from text to number. I have tried to do a update query from the field set as a text datatype to a field set as a number datatype and this does not work.

Can this be done through VBA or SQL? Or maybe some other way?

Any help would be appreciated.

[RuralGuy]

Have you tried importing your .CSV into a separate .MDB and work on it in there?