If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel VBA-Geting data from Access
My problem is that I don't know how to connect to an Access database
from Excel. I'm modifying a macro in which I have to compare some strings in Excel cells to the data in Access database with a single table. It's not a SQL problem. I found some code in the help files, but since I'm not a VBA programer I didn't work out anything. I'd be very thankful for any help. ps. I'm runing on Office XP Aleš Kodrič --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Excel VBA-Geting data from Access
Check
http://www.able-consulting.com/tech.htm and http://www.erlandsendata.no/english/...p?t=3Denvbadac --=20 Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , kodricales=20 says... My problem is that I don't know how to connect to an Access database from Excel. I'm modifying a macro in which I have to compare some strings in Excel cells to the data in Access database with a single table. It's not a SQL problem. I found some code in the help files, but since I'm not a VBA programer I didn't work out anything.=20 =20 I'd be very thankful for any help. =20 ps. I'm runing on Office XP =20 Ale=A8 Kodri=E8 =20 =20 --- Message posted from http://www.ExcelForum.com/ =20 =20 |
#3
|
|||
|
|||
Excel VBA-Geting data from Access
This might be a help for getting data to and from Excel and Access: It
includes examples of using variables in SQL queries. http://www.bygsoftware.com/examples/sql.html Or you can get there from the "Excel with Access Databases" section on page: http://www.bygsoftware.com/examples/examples.htm It demonstrates how to use SQL in Excel's VBA to: * create a database, * create a table and add data to it, * select data from a table, * delete a table, * delete a database. DAO and ADO files available. You can also download the demonstration file called "excelsql.zip". The code is open and commented. -- Regards Andy Wiggins www.BygSoftware.com Home of "Save and BackUp", "The Excel Auditor" and "Byg Tools for VBA" "kodricales " wrote in message ... My problem is that I don't know how to connect to an Access database from Excel. I'm modifying a macro in which I have to compare some strings in Excel cells to the data in Access database with a single table. It's not a SQL problem. I found some code in the help files, but since I'm not a VBA programer I didn't work out anything. I'd be very thankful for any help. ps. I'm runing on Office XP Ales Kodrič --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|