Thanks.

I still shows 1 row affected but the output does not return any results.

That is all I wanted to make sure off, I want to make it sure of one...

I just saw when I selected *, it made the column names vat# instead of vat., so that was the problem. Thanks for everyone's patience, time and help in this...

Now it says my last to column names are invalid, but I copied it from the spreadsheet into my select statement, so how can they be invalid?

:blush: sorry that was a crazy stupid question..I am so stressed about this thing I am making stupid mistakes now..let me just take a quick break

Hi Gila,

It works with the following code:

SELECT * FROM OPENDATASOURCE( 'Microsoft.ACE.OLEDB.12.0', 'Data Source="D:\DatabaseAdmin\EuroSales.xlsx";

Extended properties=Excel 8.0')...EUROSALES$

Just one question, how do I now select only the columns that I want, because sometimes...

Sorry I didn't see that. Will will try it and let you know what happens.

I have now moved it out of the root drive but I am still getting the same error

I have now moved it to the D drive and the statement I use is as follows:

insert into mpsales.salesreports

select *

from openrowset(bulk 'D:\EuroSales.xlsx',

formatfile = 'D:\SalesReportsFF.xml')as t1

The errors are:

Msg 4866, Level 16,...

Sorry the letter part I just missed when I highlighted it to copy it. It is in there and then I get the same errors.

insert into mpsales.salesreports

select *

from openrowset(bulk 'C:\EuroSales.xlsx',

formatfile...

I get the same errors when using openrowset.

Just below those first errors I pasted my openrowset statement, but it is returning the same errors.

Hi, I have installed the driver but I am still getting those three error. I am using a format file so I don't understand why the first error says the...

I already have the Access Database Engine drivers on. Would the version of the driver make a difference?

Hi,

I did see that I didn't highlight the drive when I copied it in here but it is in here.

I have fixed the format file as there was a spelling...

Hey Gila,

I have sorted it out. My focus was on the wrong part of the case statement which was char data.

Thanks man.

Hi Gila, well that makes sense hehe.

Is there a way to find out which row is causing the problem?

I have made the length of the decimal (25,2) and I still...