Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel and Dbase
I have been asked to build an appliation with a DBase back end and
Excel front end. I have built a mockup in access and I am now trying to convert it to DBase. Can one connect to DBase using ADO (later on I run queries) and what is the equivalent line for Dbase Cnct = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & ThisWorkbook.Path & "\SampleData.mdb;" Set Connection = New ADODB.Connection Connection.Open ConnectionString:=Cnct Thank you in advance for your help Jeremy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel and Dbase
Thanks for your help
Jerme *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dBase IV and VBA in Excel 2007 | Excel Discussion (Misc queries) | |||
Should/Can Excel be used as a dbase | Excel Discussion (Misc queries) | |||
2007 Excel to Dbase | Excel Discussion (Misc queries) | |||
Dates in an Excel Dbase | Excel Discussion (Misc queries) | |||
Working with DBASE 4 and Excel | New Users to Excel |