Import to SQL 2008

[people3]

HI All,

I have a simple excel 2007 file consisting of one sheet with 7 columns,

I have a SQL 2008 server with a database with a corresponding table, and field.

From excel how can I export the data into SQL.

I need a user to be able to click a button to upload the info to the database which we use to populate a web page.

Any Help would be great

 

[SkipVought]

Hi,

This will take VBA using ADO. Please post in forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}