Importing an TXT file into Access

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I have this txt file that is jumbled up and need to import it with some
changes in.

1. need to seperate the city state zip into the table without it being
combined.
2. Need to add the file name to the table where the information is coming
from.
3. Need to use the numerical value of the data into the table. example it
might say Apple but in the lookup its a 1. Can u please help. i have an
example to work with but not sure how to approach it. If you want to see the
example please send me ur email. thank you so much
 
I have this txt file that is jumbled up and need to import it with some
changes in.

1. need to seperate the city state zip into the table without it being
combined.
2.  Need to add the file name to the table where the information is coming
from.
3.  Need to use the numerical value of the data into the table.  example it
might say Apple but in the lookup its a 1.  Can u please help.  i have an
example to work with but not sure how to approach it.  If you want to see the
example please send me ur email. thank you so much
Click to expand...

two options. One is to import into a temporary table that you can
query and fix your data. Then import into the final table. When you
append the data to the final table, you can update the records where
the FileName/Source is Null to the name of the current file. (If you
use the OpenFile API to get the filename, it could be stored in a
variable, which you could access via a VBA function.

Lookup tables. You can write a query to join on the actual field
value and then update another column that contains the ID for your
company name.
 
Back
Top