If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|