how do i convert data from excel into sql

Can anyone please tell me how to convert data in excel spreadsheets into SQL?

or convert MS-Access database to SQL or mySQL ?
or convert Excel spreadsheet into mysql or sql

(I then want to use ASP to query the database)

i don't know if you can convert an xls to sql but you could create a sql db structure and then export the data from the xls to a csv and then import it into your sql db! that is what i'd do!!

RF

Can;t you just query the Access db you already have?

depends on his programming language/hosting platform !!

you can do it.. I have done it(for access and excel) calling it from the SQL server 2000..
(i know how to do it only with SQL server, if you are interesting)..
I don't have SQL server in that PC,
I'll send you the steps when I go home if noone reply untill then..

surely just converting the data to csv then uploading it would be quicker thouhg?

I don't know.. I anlways use SQL server to convert excel and access..(and it has a thousand options-I like it)

fairy nuff! Something that is irritating abuot converting an xls to csv is if someone has used a comma in one of the text fields that completle screws with the data when you import it!! So if there is a simple way to convert to sql then i guess that would be useful !

At the enterprise manager:
First of all you create an empty DB..
Then:
Databases-right click ->All tasks-> import data
At the wizard:
Data sourse: you choose what type of file you want to convert..
The next window it opens depends on what type of file you have chose..
eg, Access:
Filename ________ (you browse the file you want to convert)
Username________(if you have, I mean i your db is password protected)
Passwort_________(If you have)

Next>

you choose from the list to what you want to convert your mdb file and you fill what it asks..
from the list with the DBs it gives you, you choose the empty DB you have created at the beginning..

next>

you choose:
copy table and views from the source DB(if you want to copy the whole DB)
or
use a query to specify the data to transfer

Next>

It gives you a list with the table and views from your access db... You choose those you want to convert

That's it!

For excel steps are similar..

I gave you the minimun options.. you can do more.. it's very easy..