View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
deko[_2_] deko[_2_] is offline
external usenet poster
 
Posts: 53
Default best way to get data from Access to Excel?

Is there a simple way to get data into Excel from Access? I've tried
TransferSpreadsheet and OutputTo - neither meet my needs. I've alse tried
using a select statement - does nto work on my system - something about an
ISAM driver... Can I loop through a recordset or something? I have one
table with one column - I just want to import the one column into Excel - no
formatting, no headerow.

Thanks in advance.