I am still getting that same error.

How can it get the data when I have a where clause just filtering the data, but as soon as I remove the where...

Hi Guys,

Sorry I was being dumb.

It will just be normal case syntax.

For some reason it only works when I have a where clause, as soon as I remove the where clause, I get the error again

Hey man,

I figured it out. The one column has a data type of small int, so I just had to cast it to int.

Thanks anyway

Thanks Mark, works perfectly

Oh ok thanks man.

The drivers I have on here at the moment for Access and Excel are the following:

MS Access dBASE Driver - ACEODBC.DLL

MS Access Driver ...

I used the openrowset noe, and the error message says:

The OLE DB provider "ACE.OLEDB.12.0" has not been registered yet.

So where and how do I register it?

I wanted to use the openrowset statement in sql but it complains about my drivers.

My final command is now:

bcp DBName.dbo.TableName IN FilePath -T -t -f FormatFilePath

This gives no error, it only says

Starting Copy....

0 Rows Copied

Network Packet Size...

I don't want to export from SQL, I want to import to SQL from the excel file. I have now created a format file but it still say starting copy,...

I created the table exactly like the spreadsheet. The format of the spreadsheet will never change and I made the data types more than big enough to handle the data...

What you says makes sense since this is what I have found when searching the error, but when I use the Import wizard to do it, it creates a new...

I have now changed the file name to Capitals, is the bcp case sensitive?

Now it says starting copy, then gives me SQLState = 220011, Native Error = 0.

String data right...

Hi Shafat,

The second one works perfectly.

Thanks man appreciate it.