Excel XP: sending data to SQL Server 2005

W

Webtechie

I have a test file with differently formatted rows.

0x00, Jane, Doe, teacher
0x01, Central Highschool, math Test
0x02, 88,80
0x01, Central High school, english Test
0x02, 92,93
0x01, Central Highschool, lang. arts Test
0x02, 77,87

I need to write a macro to parse out this file and end up with data for
three tables in SQL Server:

1) Teacher
2) Exam
3) Grades

I was wondering once I have the rows parsed out, what is the best way to
update the tables in SQL Server?

I saw one thread where someone was exportint to XML. I can do that if I
need to.

I know SQL Server very well and can program in Excel fairly well. I've
imported data from SQL Server into Excel, but never sent data to SQL Server
from Excel. I saw one thread, but I wasn't able to follow it at all. If
someone could help me to get started that would be great.


Would Excel 2007 be any better with this?


Thanks.
 

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

Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server 0
import Excel worksheet to SQL Server table 7
Importing Excel data with macros to SQL server 1
Push data from Excel to SQL Server 2
How do you code to get SQL Server data from ODBC Connection? 0
VSTO Excel Rows to SQL Server 2005 2
VBA to export large tables from Excel to SQL Server 1
Passing dates to Sql Server 2005 stored procedure 3

Top