Sample Code Request for Importing SQL Tables to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, currently, I am using Excel 2000. I would like to do the below in VBA. I
am new in SQL Programming in VBA. To help you to understand myself better, I
have been programming in VBA for Excel quite sometimes. But for the below, I
am totally new.
Pls help me. It is urgent.

01) Check that a local pc connected to an SQL Server (This server is located
in my
office) successfully.
02) Connect to the SQL Server.
03) Open the database.
04) Open a table in this database.
05) Extract this table.
06) Copy all extracted records and paste in one worksheet in my Excel File.
07) Close the table.
08) Close the database.
09) Close the connection.

You may reply to my below email addresses.

01) (e-mail address removed)
02) (e-mail address removed)

Thanks and Best Regards
Sandra Poh
 
Sandra,

I may of missed the point but if your using sql server could you not
just run a select * (your table name) and 'save results to file' as a
txt file and then import the text file into excel?

HJ
 
You must log in or register to reply here.

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

Sample Codes for SQL for Excel VBA 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
What are the steps to fix damaged MDF files in SQL Server? 0
date format in excel imported from an SQL DB. 2
EXCEL export to SQL query 1
MSAS will expire in 7/31/2005 10
import Excel worksheet to SQL Server table 7
Excel interface to SQL 1

Back
Top