External Database Lookups

[SIG357]

I'm trying to create a utility that iterates through a folder full of dBASE IV files and renames them, but I need to grab a value from each database to do the renaming.&nbsp;&nbsp;I've tried SELECT...INTO statements to no avail, and the TransferDatabase action both in a Macro and in VB.&nbsp;&nbsp;It always says that the Jet DB Engine cant find this object (the database name) or some other similar error message.&nbsp;&nbsp;Is there something I'm doing that's fundamentally wrong?&nbsp;&nbsp;Do I need a preset ODBC link to the database I want to open?<br>Thanks much<br>Joe

 

[DougP]

Lets see you code example...<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[SIG357]

I've tried this two different ways, and I seem to be getting the same errors. As far as I can tell, I'm following the sytax correctly for both operations.<br><br>strTrackNumber = dbRename.OpenRecordset(&quot;SELECT * FROM &quot; & Mid(RenameFile, 1, Len(RenameFile) - 3) & &quot; IN 'C:\Upload' 'dBASE IV;' WHERE Track_No LIKE '1z*'&quot.Fields(0).Value<br><br>DoCmd.TransferDatabase acImport, &quot;C:\Upload\&quot;, acTable, &quot;May26_001.dbf&quot;<br><br>Thanks