Migrating from Excel to sql-server

Hello,
I have got the job to migrate data from an Excel-sheet to a
sql-server-database. I have a lot of experience with Access but
Sql-Server is not in my line.
So who can give me some advice about how to do this job?

thanx for your help, HelmutEasiest way is to use the Data Transformation Services (DTS) of SQL Server.
It has a nice UI.

Start > Programs > Microsoft SQL Server > Import and Export Data

HTH,
Dave

"Helmut Blass" <helmut_blass@.tweb.de> wrote in message
news:bplp9f$olf$07$1@.news.t-online.com...
> Hello,
> I have got the job to migrate data from an Excel-sheet to a
> sql-server-database. I have a lot of experience with Access but
> Sql-Server is not in my line.
> So who can give me some advice about how to do this job?
> thanx for your help, Helmut

Microsoft SQL server Virtual Backup specification

Hi,
My task is to freeze SQL server so that it can be in a consistent state and after my job is done i need to thaw it. I have gone through the VDI specification given by Microsoft SQl server. It is concerned with APIs to third party vendors to take backup of SQL server with or without snapshot. Using that is there a way to do my task ?

Thanks in Advance

Can you tell us a little more about what you're trying to accomplish?

Are you building your own backup app, or what are you accomplishing by freezing the database?

There may be other less disruptive (and easier) methods to use, depending on what you're needing to do.

|||Hi Kevin,
Thanks for the reply.I want to build a backup application. But according to my requirements, i cant install VSS agent on the machine. Is there any way to freeze the SQL server using VDI ?

Microsoft SQL server Virtual Backup specification

Hi,
My task is to freeze SQL server so that it can be in a consistent state and after my job is done i need to thaw it. I have gone through the VDI specification given by Microsoft SQl server. It is concerned with APIs to third party vendors to take backup of SQL server with or without snapshot. Using that is there a way to do my task ?

Thanks in Advance

Can you tell us a little more about what you're trying to accomplish?

Are you building your own backup app, or what are you accomplishing by freezing the database?

There may be other less disruptive (and easier) methods to use, depending on what you're needing to do.

|||Hi Kevin,
Thanks for the reply.I want to build a backup application. But according to my requirements, i cant install VSS agent on the machine. Is there any way to freeze the SQL server using VDI ?

Microsoft SQL server Virtual Backup specification

Hi,
My task is to freeze SQL server so that it can be in a consistent state and after my job is done i need to thaw it. I have gone through the VDI specification given by Microsoft SQl server. It is concerned with APIs to third party vendors to take backup of SQL server with or without snapshot. Using that is there a way to do my task ?

Thanks in Advance

Can you tell us a little more about what you're trying to accomplish?

Are you building your own backup app, or what are you accomplishing by freezing the database?

There may be other less disruptive (and easier) methods to use, depending on what you're needing to do.

|||Hi Kevin,
Thanks for the reply.I want to build a backup application. But according to my requirements, i cant install VSS agent on the machine. Is there any way to freeze the SQL server using VDI ?