Insert Into Table Question! 1

[proximity]

Hi,

I am attempting to take some data off a database on a usb drive and append it to a table on the c drive. I can't get the syntax right . . . ! Any ideas:

DoCmd.RunSQL "INSERT INTO tblEdadCollation1 " & _
"SELECT tblEdadCollation.* " & _
"FROM (A:\Removable Storage\EdadDataTransferUtility.mdb).tblEdadCollation " & _
"WHERE (A:\Removable Storage\EdadDataTransferUtility.mdb).tblEdadCollation.Date=Date()-30;"

Thanks, as ever,

--
Steven

 

[Remou]

How about:

[tt]DoCmd.RunSQL "INSERT INTO tblEdadCollation1 " & _
"SELECT X.* " & _
"FROM tblEdadCollation X " & _
"IN 'A:\Removable Storage\EdadDataTransferUtility.mdb' " & _
"WHERE X.Date=Date()-30;"[/tt]

 

[proximity]

Thanks Remou,

That worked brilliantly!

--
Steven