importing a cvs file

G

Guest

question: I received several csf files but when you open them
they open in excel format, is there a way ti import all these files
into 1 access table??? Does anyone have sample code that shows
you how this works??? many thanks for any help or suggestions....
Eric
 
P

pietlinden

question: I received several csf files but when you open them
they open in excel format, is there a way ti import all these files
into 1 access table??? Does anyone have sample code that shows
you how this works??? many thanks for any help or suggestions....
Eric
Click to expand...

How many is several?

The easiest way is to
File, Get External Data,Import, Scroll down the "Files of type"
dropdown to Text.
 

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

importing csv files 1
Importing CVS files into Excel 2
Excel and CVS 2
import/read a text/prn file from line, say, 5 1
Can't Import CVS file 3
Importing data from Excel 2003 to Access 2003 4
import ignores the text format in table's field 1
Importing CSV file to Access 3

Top