Import Excel into Ms SQL 2005 Automatically

[fdeasy]

Hi All,

I'm having problem with import excel into MsSQL automatically, i knew that we can import the file manually from MsSQL.
However, i want it to run automatically. is it possible? I've heard that, its possible if we use script. And I have no clue how to write the script, cause im really new to it. Anyone can help me? Thanks

[vinod]

there are some tools avialable in Net for this .try through google.those tools will take this excel sheet as input and gives mssql database.first u should create the database and tables according to the datatypes.try through google.i worked once on that

[cbellizzi]

Hello are you using SSIS? If so you can use the file watcher object that you can download from SQLIS.com. Just amke sure that the structure of the .xls is the same each time. cjb-

[getsaby]

There are various tool avaiable, which can import any document, in to ur MS SQL database.

try this one its works really gr8, its a wizard that will guide you.

"SQL Manager 2005 for SQL server"

[fdeasy]

Hello are you using SSIS? If so you can use the file watcher object that you can download from SQLIS.com. Just amke sure that the structure of the .xls is the same each time. cjb-

Thanx, i'll try to do with that. hopefully, it'll be worked :)