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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
trying to capture data from a table that I have to create a new table
Okay - I think I'm getting somewhere . . . here's what I've done so far. Private Sub btntest_Click() Set rstEBPData = CurrentDb.OpenRecordset("tbl_test1", dbOpenTable) ' this is the input table Set rstACTData = CurrentDb.OpenRecordset("tbl_test", dbOpenDynaset) ' this is the actual...- tmpennin
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
trying to capture data from a table that I have to create a new table
I am trying to create a new table from an existing table. The existing table is created from an import command ( DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "tbl_test", "S:\vata\surlak - Go To Sleep\Import Data Code\Actiwatch sample.xlsx", True). I have to find where the new...- tmpennin
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
