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

P

petty

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
 
M

M.L. Sco Scofield

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
 
Top