Hi
I have an access database, where I import some text files (by saving excel worksheet as txt) to Predefined tables in Access. Some queries are then run, which use these tables. I need to automate this process.
So what I basically need to do is, use an excel macro, which makes the Access Db to import the text file to a table and then run the access queries.
I am completely new to Access database and have no idea where to begin. I am not aware if exporting excel worksheets instead of text files will work as I have no backend knowledge of the database. I have basic knowledge of Excel VBA.
Any help will be greatly appreciated!!
TIA
Bookmarks