Text files

G

Graham Bennet

Hello All,

What is the best way to input data into a table from text files.

Graham
 
J

Jonathan Parminter

-----Original Message-----
Hello All,

What is the best way to input data into a table from text files.

Graham
Click to expand...
Hi Graham, your post is a little vague. I assume you want
to automate importing text files?

If 'yes', then I suggest that you use manually import the
text file. When completing the steps of the import wizard
save an import specification with a descriptive name. Use
either a macro or vba to import the text file using this
saved import specification. Lookup online help for
TransferText for more information.

Luck
Jonathan
 
G

Graham

Thanks Jonathan


Jonathan Parminter said:
Hi Graham, your post is a little vague. I assume you want
to automate importing text files?

If 'yes', then I suggest that you use manually import the
text file. When completing the steps of the import wizard
save an import specification with a descriptive name. Use
either a macro or vba to import the text file using this
saved import specification. Lookup online help for
TransferText for more information.

Luck
Jonathan
Click to expand...
 

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

Treating multiple paragraphs as one 2
Assign Formatted Block of Text to Theme 0
Excel does not accept text format! 0
Replace in a group or selection or collection of word files 1
Outlook 365 overriding formatting choices 0
Embed the same Excel multiple times 0
Word OLE to check spelling in text box 1
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0

Top