Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Opening a local recordset in Access
Thanks, the object is succesfully created, then.. how can I open a specific table of the local database (CurrentDb) ? The instruction: Set myRec = CurrentDb.OpenRecordset("TabellaGale") doesn't work.... maybe I've to use some specific instruction for Ado interface....- ilgale
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Opening a local recordset in Access
I'm in Access, and I've to develop and application that import data from an Excel SpreadSheet and copy such data into an Access table. I've used the following code to open the Excel Spreadsheet: Dim xl As Object Set xl = CreateObject("Excel.Application") xl.Workbooks.Open...- ilgale
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
