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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to append all recors from ADODB.Recordset to an Acces 2007 Table

Status
Not open for further replies.
cparralesl

cparralesl

Programmer
Jan 27, 2002
118
NI
Hi Guys,

I've searched similar posts with no luck.

I need to create an Access 2007 table from an ADODB.Recordset, but i do not have any clue.

I can create a table from another table using this:

[tt]dbsCurrent.Execute "SELECT Journal.* INTO JOURNAL01 FROM Journal;"[/tt]

But using ADODB, i do not know how to.

I will appreciate your feedbacks about it.

Best regards,

Cesar Humberto Parrales
Application Support
 
Status
Not open for further replies.

Similar threads

Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
350
Viswa.R
Viswa.R
BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
1K
dhookom
dhookom
btamsgn
  • Locked
  • Question
How to add lines from textbox to table 1
Replies
8
Views
235
MattGreer
MattGreer
Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
636
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Add multiple contacts to outlook - from access table
Replies
12
Views
383
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top