are those errors you posted occurring in SSMS when you try to set up the linked server?

what are you expecting the results to be from your post?

what other tables do you have that store this data.....?

I agree with Luis...normalise your data...

what are you expecting the results to be from your post?

what other tables...

just a thought...but appears to work, but maybe I am not entirely clear on the issue

IF OBJECT_ID('Tempdb..#Redondeo') IS NOT NULL

DROP TABLE #Redondeo

CREATE TABLE #Redondeo (

Orden INT Identity(1, 1)

, Valores MONEY

)

INSERT...

you are trying to set up the linked server in SQL (via SSMS) ??

pity...have time to help now...but tomorrow will be fine...hopefully someone else will pick up as well

what error message?

what command wont work?

were you...

try this and see if it helps

EXEC sp_configure 'show advanced options', 1

RECONFIGURE

GO

EXEC sp_configure 'ad hoc distributed queries', 1

RECONFIGURE

GO

EXEC sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1

GO

EXEC sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1

GO

EXEC master.dbo.sp_addlinkedserver

@server = N'<linked server...

just a thought...set up a linked server...that way you can push/pull Access

clue....

SELECT COMPANY, COUNT(*)

FROM [CPACONTACTS].[dbo].[CPACONTACTS2]

GROUP BY COMPANY

ORDER BY COUNT(*) DESC

have you tried this suggestion

http://visakhm.blogspot.co.uk/2013/12/how-to-solve-microsoftaceoledb120-error.html

shot in the dark

SELECT * FROM

OPENROWSET('Microsoft.ACE.OLEDB.12.0',

'Excel 12.0;Database=E:\TestFiles\ExcelFile.xlsx';

Extended properties=Excel 12.0', [Sheet1$])

ok...my thoughts,,,warts n' all 😀

first some sample data I've made up that I hope is somewhat similar to your situation

use [tempdb]

GO

SET NOCOUNT ON

/* build some example tables*/

IF OBJECT_ID('tempdb..Tally') IS NOT...

halifaxdal (7/21/2014)

---

yes the wizard is straight forward, I just did it again, if I simply chose Ragged right, there is only one column defined and executing the package will error...