Hi,
I don't know SQL and just started to use SQL in VBA but the codes are totally strange to me. The below codes are basic SQL which are most required to proceed further, so I would be grateful if anybody explain what does the code says?
Please Login or Register to view this content.
The code tried to access a database named dbPath. Once you are connected to server, you are creating a table. You normally do it on the database itself (Directly), but you are now connecting to server from excel and creating a table as if you are on the server.
Last edited by AB33; 06-24-2016 at 11:59 AM.
Thanks AB33. Now I understand most part of the coding.
However I couldn't run the code second time, it shows error in the following codes (Database Already exist error)
(Table Already exist error)Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by wincross; 06-24-2016 at 12:21 PM.
Hi,
Can anybody help me on the above?
No data base allows to create another one if it is already exist.
Each owner of database has its own syntax, so you need to check your database provider.
Why are you using SQL like this on the open workbook? You really shouldn't be doing that
Hi Kyle123,
I am a moderate VBA programmer, can write any kind VBA automation but nothing know about SQL or Database or Access. Just started to learn those things while no work at office. I don't know how and where to use SQL in VBA. I saw the above codes in a website, started to reading, understanding and executing. Could you please help on how to use SQL in VBA if this is not the proper way to use?. Sending me an URL which tells this would also be helpful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks