Using ADO to create and insert into Access table

D

Don

Hello, I'm using Access 2003 linked to SQL Server 2000. I'm currently
calling stored procedures that create and populate a access table, then I
use DoCmd.TransferText to push the table to a text file that Word documents
use. My problem is that my stored procedure now passes back more than the
255 fields that the SQL Pass Thru Query allows. Is there a way using ADO to
create and insert the access table kinda like how I'm doing below

Thanks

MyDB.Execute "Drop Table " & v_tmpspResultsName

SQLString = "SELECT " & v_Dynamic_QueryName & ".* INTO " &
v_tmpspResultsName & " FROM " & v_Dynamic_QueryName
MyDB.Execute SQLString

DoCmd.TransferText acExportDelim, , sInternalTable, sPathNameTextFile &
sTextFile, True
 
Top