So far the fastest way I've found it to open an ADO recordset, save it as XML, and then open the XML file in Excel. I think it would probably be even faster to go from Access to text file (maybe CSV) then open that in Excel. But I'm not sure how to quickly go from Access to a text file. I don't see a way to save from ADO to a text file. Does anyone know of a way without writing my own code to write to the text file in a loop?
This doesn't have to be pretty. I'm using a VB program to graph the data in a chart and I just need to move the data quickly from Access to the invisible spreadsheet behind the Excel chart.
Any help is appreciated.
2006-10-26
08:33:57
·
3 answers
·
asked by
blue_prince_of_dallas
2