Two questions

[FDR]

Okay, first off, I'm still getting the hang of this crazy thing called VB. So if you'll all be willing to forgive me if I'm slow to pick up...

Sencond, my questions:

First Question:
I'm trying to import 5 text files into an Access DB. I found a VBA command for importing data in Access - DoCmd.TransferText
How can I access this command from VB 5.0?

Second Question:
Once I've imported the files, I want to delete them. Should be simple, but I want to be sure I've got it right before I try and accidently wipe my HD. ;-)

FDR

[JHausmann]

Question 1, I'll defer to others.

Question 2, make a backup copy of the files that you can restore. Then, programmatically, delete away.

[chriskeeble]

I'm trying to do the same thing - if anyone provides the answer please can you let me know? (E-mail me as I won't be notified - this isn't my posting).

Please help us!!!

------------------
Chris Keeble
www.giglist.com
mailto:[email protected]

[Lori]

Go into Project|References... menu and add the Microsoft Access Object Library.
Now try the following call:

Dim MyAccessDB As Access.Application

MyAccessDB.OpenCurrentDatabase ([path and filename to your db])
MyAccessDB.DoCmd.TransferText (options you want to set)

Let me know if you have any more problems with this :-)