Import txt file with different number of columns than table (1 Viewer)

griffins69 · Apr 19, 2010

I'm trying to import a txt file with 24 columns into a table with 25 columns. Then I would like to update the one empty column with a string 3 characters long.

I will be importing 5 different files into this table and I will need to update that blank column with 5 different 3 character strings.

I currently use "Docmd" below, but now that I added a column I assume I need another method.

DoCmd.TransferText acImportDelim, Import_Specs, tableName, FileName, True

jdraw · Apr 19, 2010

griffins69 said:
I'm trying to import a txt file with 24 columns into a table with 25 columns. Then I would like to update the one empty column with a string 3 characters long.

I will be importing 5 different files into this table and I will need to update that blank column with 5 different 3 character strings.

I currently use "Docmd" below, but now that I added a column I assume I need another method.

DoCmd.TransferText acImportDelim, Import_Specs, tableName, FileName, True

An approach:

Import the data into a 24 column table.
Add the new column (#25)
Update the new column with your 3 char fld where the first column is not null.
Import the second file to a known table (same table as before)
Update your 3char column with new query where 3char column is NULL.

griffins69 · Apr 19, 2010

I will be importing the data into the same table all the time. The first time it works, but I get an error once I try importing into the table with 25 columns.

griffins69 · Apr 19, 2010

I think my error is one file I'm bringing in......I will play with the file
I will update the file as I bring them in.

Thanks

Import txt file with different number of columns than table (1 Viewer)

griffins69

griffins69

jdraw

Super Moderator

griffins69

griffins69

griffins69

griffins69

Similar threads

Users who are viewing this thread