Getting data from AS400 to Excel with SQL

G

Guest

Today I use MS Query (and excel 2003), but it is too timeconsuming and
inflexible for me. I know there is severeral way of doing this, but whitch is
the easiest?

What method of connection? ADO, DAO, ....

Where do i find a good explanation for hove to use and bulid SQL within VBA?

Thx Steinar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import Excel worksheet to SQL Server table 7
MS Query - From in SQL 3
AS400 Date value conversion to Excel 5
VBA Excel data to SQL Sever table 1
Excel as front end and SQL Server as back end 0
ADO SQL: Im getting CRAZY 4
dilemma with getting sql data 4
Using Query to return data from SQL database 3

Top