Hi Ike,

How are you doing? I am greatly appreciated your helps, I already solved the problem by using SSMS or Import/export wizard. You are very nice person, and may god...

Hi there,

I used the SSIS or import/export wizard to import the data from excel to SQL and it gives me syntax errors. DO YOU KNOW WHAT WRONG? I checked the...

Hi

Where can I find the SSIS or import/export wizard? can you send me a link of how to use it?

Thanks

What if the first row is header name? where should I type the formula? However, what do you call this method? and in my excel file, there are multiple columns...

Hi Gosta,

Thanks for the comments, can you show me how to save ExcelSheet in tab txt format and how to use bulkinsert (i mean what is the command of using...

I connect to sql server using sql.

For the service account for sql server service, how can I figure which service is for my sql server ?

Thanks Ramesh, but It's still not working. 🙁

Do you have different method?

I use SQL SERVER 2005

I did as he said but It did not work.

What is it mean when you said: "Give the read/write permissions to the directory "P:\TranAssignments\ROCAPData" to SQL Service Account or Everyone (only if security is not an issue)"

I saved Excel...

Hi Ramesh,

the file "P:\TranAssignments\ROCAPData\ROCAP.xls" is located on my PC and Server is also located on my local Server

DOES ANYONE OUT THERE KNOW HOW TO TRANSFER THE DATA FROM EXCEL TO EXISTING DATABASE IN SQL 2005?

Thanks

One gentlement suggested me to use Adhoc query but I don't know the command, DO YOU?

This is what I typed:

Select * FROM OPENROWSET

(

'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0; IMEX=1; Database=P:\TranAssignments\ROCAPData\ROCAP.xls', 'Select * from [Sheet1$]')

Here is the error message:

Msg 7399, Level 16, State 1, Line 1

The OLE DB...

Hi Ramesh,

I tried your codes but it's still not working... 🙁

Here what I did before your comments

I tried to transfer the data from Excel spreadsheet to database in SQL 2005.

...