data migration from excel to sql server

Anon

Hi!

I want to convert all my excel files in to sql server database.

how can i do this.

please help me out in solving this..

thanks

manjula.

crislewis

The task of actually getting data from excel into sql is quite easy. Excel has an export function and sql has a import (LOAD) capability.

For you though I suspect thesimple moving of data from one to the other may not be the issue.

One is a spreadsheet that can be used as a (simple) database. The other is a powerful relational database that is anything but a spreadsheet.

Excel will forgive many stuctural problems with data. SQL will be much less forgiving.

First step is to review the data in excel - both quality and structure. Clean it all up. 'Normalize' the data so that you can use the power of a DB like SQL better. Once the data is clean and well structure simply 'export' from one and 'import' to the other.

Cheers,

Cris

Anon

Hi
I have done same thing in between excel2000 and msaccess2000.
in access u just go to file menu, click on getexternal data, import.
it will ask you from where you want to import. select the excel file and it will ask you whether you want to import in the existing table or want to create new one.
just try in this way. i think the same should work for sql also.

Reply back if it works.

Manjula wrote:

Hi!

I want to convert all my excel files in to sql server database.

how can i do this.

please help me out in solving this..

thanks

manjula.

totof06

or:

http://www.phpbuilder.com/forum/read.php3?num=1&id=122909&loc=0&thread=122909

Christophe
www.realscale.com

Anon

Excuse me, but have anyone try to really do that? If it does not work , is there any way to do this other than using BCP? Doing a project like this right now and would like to know? Is it got anything to do with ADO programming??

Anon

Hello,

I have around 200 excel files to be converted in a single SQL Dtabase in a single table. I have to develop a program in VB for this data migration.
Can U guide me?

regards,

Parikshit.