Populate table from recordset

M

MChrist

Can someone point me to a good example on how to populate a table from a
recordset.

I have a stored procedure on an MS SQL Server that links tables tables
between an Oracle DB and the SQL db. Because of the size of the Oracle
tables, it's most efficient to EXEC sp_ExecuteSQL in the MS SQL Servers
stored procedure than to try and link the different tables directly in
Access. The record count that's going to be dropped down is at least 1/4
million records, so I'm looking for an efficient way to add them to a table.

My problem is, I can't figure out how to get the records from the stored
procedure into a table so that queries can be run against it.

TIA

Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Populate One Pages from spreadsheet 0
Format column widths from one table to a separate table on same page 1
Adding data to MS Access from csv file 0
Access 2010 DB not fuctional with multiple users 2
populate listbox form database table 0
recordset vs collection 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
linking to SQL Server db table 6

Top