Sorry I know this was 6 years ago but the issue still exists in 2018 with Excel 2013 / 2016 and SQL Server 2012 / 2014
To cut the story...

Hi

I have just experienced that issue.

Solution: edit the server in the connection string of the SQL query in Excel:

Open your Excel spreadsheet,

Click in the data area (where the data...

Hi

Have you tried to replace all the single quotes '' with square brackets [] ?

Single quotes in SQL Server are text delimiters

whereas square brackets are words/names delimiters

so instead of:

SELECT

...

__________________________________________________________

Looking at the 100's of posts out there, I do believe it is a generic errror message that DOES NOT SAY ANYTHING.

In our case it was the INTEGRITY checks of...

__________________________________________________________

Looking at the 100's of posts out there, I do believe it is a generic errror message that DOES NOT SAY ANYTHING.

In our case it was the INTEGRITY checks of...

Hi David

I do not have time to test all this

but let's hope it gives you a start

All the best

Alain

-- ----------------------------------------------------------------------------

-- 1) Create a new table and inserts the rows/records you...

Hi again Manish

I'd just like to add this link to a good (if rather old) white paper:

---------------------------------------

http://www.eps-cs.com/pdf/whitepaper_migrating.pdf

Migrating Your Visual FoxPro Application to a Client/Server Platform

by...

Hi Manish

First of all, try to always be specific in your title:

eg: Migration from VFP and Foxpro to SQL Server

Secondly try and search for the same subject in this...

'-------------------------------------------------------------------------------------------

Public Function fncTest(strIn As String) As Boolean

Dim cn As New ADODB.Connection, sql1 As String

Dim rs As New ADODB.Recordset

Set...

I share your concern, we have 100's of Access databases floating around.

However there's nothing wrong in letting end-users prototype their idea in Excel/Spreadsheets or Access/Small database as it saves a...

I've been struggling with DTS since I started using it 2 years ago (but when you make it work it's brilliant), but using Google "import XML" SQLXML Microsoft ... (210...