Hi everyone. I'm a new Access user. I've outgrown my Excel database and am converting to Access.
I need help linking a CSV file using VBA code. I've been successful linking the CSV file using the "External Data" > "Import & Link" > "Text File" wizard. I've also been successful in making a button Macro import the CSV file. I was hoping to use the "Convert Macros to Visual Basic" function to see what the underlying VB code is, but for some reason the button is grey and cannot be clicked.
My Macro uses the "ImportExportText" Action. What is the equivalent VBA code for this action? I cannot figure it out.
I've search Google and tried using
Code:
DoCmd.TransferText acImportDelim, "", "Table1", "C:\Winxp\testing.csv", True, "" ' where table1 is your table
but that didn't work.
Someone please help.
Thanks in advance.