How to get started with VBA to Import a Text.txt file

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

The file is located in the C:\ drive. C:\Text.txt
I need to create a button to call a procedure to import a text file.
Please point me in the right direction to get started....

I know how to create buttons to call macros and/or procedures ...
I need help on getting started in VBA - OPENFILE C:\Text.txt ????

Thanks.
 
Try something like:

DoCmd.TransferText acImportDelim, , "MyTable", "C:\Text.txt", True

use False if the first row doesn't have fieldnames
 
is this possible to apply animation in the web page
Click to expand...

Neeraj, rather than asking your question about webpages as a response to
someone else's totally unrelated question about Microsoft Access, please use a
forum supporting your web editor software and ask a new question.
 
Not trying to make things more difficult, but can I import .txt data without
using 'TransferText'?
 
Back
Top