How to do database back up?

What is the command to get the back up value?

The same error which earlier i described is coming.....

Big hectic for me...

SELECT * INTO XLImport4 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\test\xltest.xls', [Customers$])

Hi Here Customers$ refers the table name?

Msg 7314, Level 16, State 1, Line 4

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" does not contain the table "Table1$". The table either does not exist or the...

My Excel is in the location: C:\testing.xls

I want to insert in the table: Table1

Database Name: WADB

Is this the following changes are correct?

SELECT * INTO XLImport3 FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',

'Data Source=C:\testing.xls;Extended Properties=Excel 8.0')...[Table1$]

SELECT...

I am getting this error.

Msg 7314, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" does not contain the table "Table1$". The table either does...

Hi I find out how to import from table to excel.

Please any let me know the process to import from excel to table.

2008

It says that not recognized command.

Mine is windows authentication. so no username and password.

How to set the path?

c:\cd C:\x.x\x.x\Microsoft SQL Server

Is it correct?

Hi I just needed how to execute the query using command prompt. can you please explain.

s. I am installing my personal pc.

While installing i am getting this error.

Thanks Kingston..

Meet you with another problem.....

Bye!!!