How convert projects vb6 to vba access

gerry66 · June 27th, 2011, 06:32 PM

Please who can help me, I have to create the same project just posted that instead of writing him in vb6 vba access I need written in 2003, because I need it for work and do not measure up

Tanks gerry66

http://myfreefilehosting.com/f/5f748991bb_0.18MB

HiTechCoach · June 28th, 2011, 10:18 AM

Before we can help we need to know your question. What are you having trouble doing?

gerry66 · July 3rd, 2011, 05:16 PM

Help me please
I need to know how to write VBA code to select
the hard disk of the computer file "TXT" and import it into a table
Access 2003 using VBA, commnon dialog and API'S without using TransfertText.
thanks gerry66

HiTechCoach · July 4th, 2011, 01:01 AM

See: Call the standard Windows File Open/Save dialog box

Here is the basic of reading a text file:

Code:

Dim FH As Integer

Dim strData As String

FH = FreeFile

Open "C:\mydata.txt" For Input As #FH

Do Until EOF(FH)

    Line Input #FH, strData

Loop

Close #FH