Recent content by prycejones

Use an append qry and use IN for the name of the database Your SQL code should look something like this INSERT INTO customers IN "c:\database2.mdb" yaah dee yaah... FROM customers IN 'C:\database1.mdb" WHERE Customer = '...etc etc ; hth pryce

Try this... (and before anybody makes any comments - we all have different ways of doing things - thank you microsoft!) Function load() Dim db1 As database Set db1 = currentdb Dim sqlstring As String ' the where clause here will speed up your record getting if it is a big table sqlstring =...

Use the DIR command. There are several constants you can use with this command, one of them is the VBDirectory. Click help|contents|find and enter "dir function". Hope this is what you want