BPWALKIN
asked on
Insert data from a view in one access databse and insert to an empty table in another access db
I have a view that is used to provide data on a web page. The access db is becoming to big to transport the entire db to the web server. How do I script the
Insert into table2 (values) Select * from table1
Where the tables reside in 2 different dbs?
Insert into table2 (values) Select * from table1
Where the tables reside in 2 different dbs?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
using incerc's solution
I get the microsoft jet database engine has stopped the process because you and another user are attempting to change the data at the same time
this is in two test datbases where no one else is connected
I get the microsoft jet database engine has stopped the process because you and another user are attempting to change the data at the same time
this is in two test datbases where no one else is connected
if you want to append records to an existing table, use "Insert into ..."
see my post at http:#a34154694
the
"select into..." is a make table query, that will create the table in the other db.
see my post at http:#a34154694
the
"select into..." is a make table query, that will create the table in the other db.
Indeed, I confirm that the "Select .. into" creates the tables. But I thought that this is better than using "insert into.." because you don't need to create manually the table.
well, from the title of the Q. it is an 'empty table' , so the table already exists
ASKER
it would be better to create the table on the fly and delete each day with ne data.
What could be the possible causes of that error.
What could be the possible causes of that error.
ASKER
my apologies I should have been clearer
For the error you received, please see this thread :
http://www.tek-tips.com/viewthread.cfm?qid=226588&page=1296
http://www.tek-tips.com/viewthread.cfm?qid=226588&page=1296
ASKER
I got it, I ran the compact and repair and it worked fine.
Thanks
Thanks
Then when the updating time comes up, do a delete all query and add teh records.. This may be a way to get around your problem.. Give it a think!