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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
export from RecordSet in VBA to Access Tabe: How do I?
Ok, I used the code you suggested, but am getting an error message: Syntax error in INSERT INTO statement Looks like the code you provided is exactly what I need, but may be missing a punctuation element (or something). Any additional suggestions? Thanks for you time and assistance!- asphynx
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
export from RecordSet in VBA to Access Tabe: How do I?
Please see current code below. My thought is that the recordset will be sent to a new table (created earlier in the routine) almost at the end of the code (a couple of lines before the End Sub). The data in the "opt" array is what I need to send to the new table. Thanks in advance...- asphynx
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
export from RecordSet in VBA to Access Tabe: How do I?
I'm developing a vba routine that imports data from one table in Access into a recordset, manipulates the data, and exports the new data to a different table, but I don't know how to accomplish the last step. Any suggestions?- asphynx
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
