Open a Text File

  • Thread starter Thread starter Nigel Bennett
  • Start date Start date
Nigel Bennett said:
How would I open a text file from within Access
Click to expand...

That would depend on what you mean by "open":

+ You can use standard VB file I/O statements Open, Input or Line Input,
and Close to open, read, and close the file in a VBA procedure.

+ You can use the DoCmd.TransferText method to import or link to a text
file as a table.

+ You can use Application.FollowHyperlink (or call the ShellExecute API)
to cause the application associated with text files to open and display
the file in its own window.
 
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

Change Field Size 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel How to Fix Damaged Excel File That Won't Open? 3
Sending a query as txt file 1
saving a report to a text file without decimals 3
Create new Word document from template 2
Is this a trim issue 4
Date/Time added to Text File 2

Back
Top