sql statement

Results 1 to 2 of 2

Thread: sql statement

  1. #1
    Join Date
    Dec 1969

    Default sql statement

    Is this possible to select all records from one table (in access database), and insert into another table(different access database)? How do I do it? For example, here is my sql select statement that I select all records from "firsttalbe":<BR>strSQL ="SELECT * FROM firsttable"<BR><BR>What&#039s the proper syntax to take strSQL and somehow insert this strSQL statement into "secondtable" as a separate database? Any helps would be appreciated. Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: sql statement

    You&#039ll need to loop through the records & insert them. It&#039s possible to do in a single SQL statement if both tables are in the same db but not across dbs.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts