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

[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.

 

[Arvin Meyer [MVP]]

Try something like:

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

use False if the first row doesn't have fieldnames

 

[neeraj kumar]

is this possible to apply animation in the web page

 

[John W. Vinson]

is this possible to apply animation in the web page

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.

 

[Jen]

Not trying to make things more difficult, but can I import .txt data without
using 'TransferText'?

 

[Arvin Meyer [MVP]]

Using VBA, it's probably the easiest method. You could always read in a file
a line at a time, but that's far more complex code.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Jen]

Arvin,

Thank you - I agree, I'm not looking to complicate matters ...

Jen