Link to home
Start Free TrialLog in
Avatar of Jordan_WM
Jordan_WM

asked on

Excel External Datasources - delimted text files

Hello,

I understand how you can use the import wizard to connect to an external datasource such as delimited text file and then use MS query to query the data that you want and import into an excel worksheet.

Is there anyway to do this from the VB code to connect to an external datasource and then query what ever coloumn I want want from the text file.
ASKER CERTIFIED SOLUTION
Avatar of rspahitz
rspahitz
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial