Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

DLL Talk / DBConn and Excel

Author
Message
SimonNeill
9
Years of Service
User Offline
Joined: 9th Aug 2010
Location: Colchester, UK
Posted: 14th Aug 2010 14:31
Has anyone had any success using the DBConn plugin and a native Excel 'sheet. I can connect to the 'sheet but CREATE TABLE SQL command fails (Excel reports "bad syntax in SQL command"). Also I have created named tables within an Excel 'sheet but INSERT INTO SQL command fails (Excel reports "cannot find table object"). Any hints or tips?
bitJericho
17
Years of Service
User Offline
Joined: 9th Oct 2002
Location: United States
Posted: 16th Aug 2010 13:57
What are your sql statements?

SimonNeill
9
Years of Service
User Offline
Joined: 9th Aug 2010
Location: Colchester, UK
Posted: 16th Aug 2010 22:40
@Jerico2day
Thanks for the reply.
I've attached two files which have the bare bones of what I've tried.
I believe the SQL statements are correct (they work fine with Access) but I wonder if they need some modification to work with Excel objects?

Attachments

Login to view attachments
SimonNeill
9
Years of Service
User Offline
Joined: 9th Aug 2010
Location: Colchester, UK
Posted: 16th Aug 2010 22:41
Oops, forgot the second file.

Attachments

Login to view attachments
KISTech
11
Years of Service
User Offline
Joined: 8th Feb 2008
Location: Aloha, Oregon
Posted: 17th Aug 2010 02:22
Couldn't tell ya. I've never done anything like that with Excel.

I would do some google searches using the words Excel, SQL, Syntax, ODBC, and see what comes up.

SimonNeill
9
Years of Service
User Offline
Joined: 9th Aug 2010
Location: Colchester, UK
Posted: 26th Aug 2010 00:35
In case anyone is interested, after a lot of experimentation the following seems to work. It's pretty much bare-bones but does demonstrate that you can use Excel with DBConn with ease.

Attachments

Login to view attachments
KISTech
11
Years of Service
User Offline
Joined: 8th Feb 2008
Location: Aloha, Oregon
Posted: 26th Aug 2010 19:16
Very cool. I'll add that source to the DBConn project page with credit to you if that's ok.

SimonNeill
9
Years of Service
User Offline
Joined: 9th Aug 2010
Location: Colchester, UK
Posted: 26th Aug 2010 20:03
@KISTech

Glad you like it.

Feel free to add it to the project page.

Login to post a reply

Server time is: 2019-10-18 23:13:13
Your offset time is: 2019-10-18 23:13:13