I am trying to create a macro in Access to delete a Table and import an excel file to create a new table. This is what I have so far but it doesn't work.
DeleteObject Type=Table, Name=TEST
TransferText Type=Import Delimited, Name=TEST, File=c:\karl\1.csv, Field Names=No, Specification...
I am learning Access VB so forgive me if this question is basic in nature. I am having problems importing a file into Access using VB. I can open the old file or delete the old file but I am not able to open and delete or import the file. Can anyone help? Karl
I am learning Access VB so forgive me if this question is basic in nature. I am having problems importing a file into Access using VB. I can open the old file or delete the old file but I am not able to open and delete or import the file. Can anyone help? Karl
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.