how do i get instructions on how to import a delimited text file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello i am currently trying to use the online help function to get
instructions on how to import a delimited text file. i need notes on how to
append the data to an existing file
 
In the help search box enter:
Import or link data and objects

"Import or link data and objects" should be the top topic

Find "From a text file" and expand "Import or link a delimited or
fixed-width text file"

This will get you the instructions to run the import wizard. When you get to
the dialog that asks about creating a new table or to an existing table,
select the table you want to append to.

FWIW, if this is a onetime import, I personally import into a new table,
make sure the data is OK, and then make an append query to copy the records
from my "temporary" table to my real table.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Using Pipe as Delimiter 4
Import from Notepad delimited text 7
Importing Text Files Into Access 1
Access 2003 can't import delimited files 1
Splitting Text in a Field Based on a Delimiter 2
delimiter 4
Import Text - Macro Issue - Semi-Colon Delimited 2
Access 2007: Import Text Wizard errors 4

Back
Top