Open MS-ACCESS and Run Saved Imports in Access

[Manikanta546]

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.

[alansidman]

run the saved import and close it

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.

[Manikanta546]

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.

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.

[alansidman]

Google is your friend:

http://lmgtfy.com/?q=import+text+file+to+access+vba