Hi,
I want to open MS-ACCESS file and run the saved import and close it. It want this action to be performed by VB script writen in excell sheet. Can any one please help me in doing this.
Hi,
I want to open MS-ACCESS file and run the saved import and close it. It want this action to be performed by VB script writen in excell sheet. Can any one please help me in doing this.
What does this mean? Can you be more descriptive and tell us specifically what you wish to do. What you are suggesting makes no sense.run the saved import and close it
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I have huge data in text file that I want to import to excell sheet and populate in a pivot table. For this what I am doing is first I am importing the data to MS-ACCESS and later I am importing from MS_ACCESS to excell sheet using data connections. For first time I imported to MS-ACCESS and saved the import process so that from next time I can directly run the saved import. Later using data connections I can bring the data to excell sheet pivot table.
I want this process to automate using VB script.
Google is your friend:
http://lmgtfy.com/?q=import+text+file+to+access+vba
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks