🚀 go-pugleaf

You should know exact query, in this case it is probably simple "select * 
from <table>". Jet supports cross-database queries, so you can write:

select * from <table> in "" [dBase 5.0;Database=c:\db_path]

This way you may construct SELECT INTO or INSERT INTO query - just <table> 
means table from current database, <table> in "" [...] means table in 
another database.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + 
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Igor Tsukanov" <darl@office.pib.com.ua> �������/�������� � �������� 
���������: news:42df388d$1@newsgroups.borland.com...
>
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote:
>>Manually - there are few lines of code to traverse recordset and assign 
>>all
>>columns. Or, better, use INSERT INTO or SELECT INTO command.
>>
>>//------------------------------------------
>>Regards,
>>Vassiliev V. V.
>>http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
>>ADO.Net
>>http://www.oledbdirect.com - The fastest way to access MS SQL Server,
>>MS Jet (Access) and Interbase (through OLEDB)
>>
>>
>>"Igor Tsukanov" <darl@office.pib.com.ua> �������/�������� � ��������
>>���������: news:42de5f2c$1@newsgroups.borland.com...
>>>
>>> How can I transfer(append all) the data from one recordset to other
>>> recordset per saltum? In my case I have one recordset with connection to
>>> Text-file, second - DBase-file. The both providers is MS Jet.
>>>
>>> Best regards
>>
>>
>
> The either recordset connected to own connection(ADOQuery1 connected to 
> ADOConnection1, ADOQuery2 to ADOConnection2 and because of I don't use the 
> select/insert etc.).