Importing Tab Delimited Text File to an Existing Table in Access

Office 2007, just upgraded from 2000 ( OMGOODNESS!! What a flippin'
NIGHTMARE!!)


I am simply trying to import a tab delimited text file into an existing
table in Access. In Office 2000, I was given an opportunity to change
the data type of columns to be imported during the import process
itself. In 2007, I am not given an option and end up with import errors
for every single row of data (over 1.5 million rows) because it reads a
text field of numbers as a number datatype. I can find no documentation
on how to solve my problem as Microsoft only provides information for
importing Excel files. Having well over a million rows, I cannot
maintain the data in an Excel file.


Thanks in advance for any help you can provide.

Rita Brasher
Project Engineer
FedEx Express


PS Here I thought I wasn't as productive as I could be because I was
behind on Office revisions. That was a joke!! Would maintaining a
semblance of similarity have been too much to ask??? If the simplest of
functions are going to all become difficult, I may have to go back to 2000.