Hi All,
This is my first time using ADO to connect to our SQL server. I keep getting a syntax error and can't seem to figure out where I am going wrong. Could someone please help me!
I have attached the syntax that I am using as the form doesn't allow SQL.
ADODB connection.txt
What error are you getting? Is it an excel error, or is the error happening when you attempt to execute the SQL command on the server?
Also, for a SQL server connection - the connection string should look like this:
Please Login or Register to view this content.
Last edited by GeneralDisarray; 08-06-2015 at 09:42 AM.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Hiya,
It says syntax error in INSERT INTO statement
nevermind- guess I missed something
Last edited by GeneralDisarray; 08-06-2015 at 10:12 AM.
There are spaces missing in the SQL statement.
If posting code please use code tags, see here.
Hiya,
I'm trying to insert values from a spreadsheet and I was using the method shown here http://stackoverflow.com/questions/3...el-into-sql-db
Hi Norie,
Could you please tell me where as I am struggling to find them
remove if you please
Last edited by GeneralDisarray; 08-06-2015 at 10:13 AM.
Between the last line and the Where clause
EDIT in fact at the end of each row
There should be spaces before SELECT, FROM and WHERE.
I generally avoid this by starting each line with a space:
Please Login or Register to view this content.
Thanks for the tip and I've sorted out the spaces but it's still giving me the same error!
Wow, I finally got IT to allow me to see that Stack Overflow link - that's a great way to do that
Nevermind my way
Last edited by GeneralDisarray; 08-06-2015 at 02:48 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks