Retrieve access data into excel

Hi

Have you tried putting the extra fields you require into the SQL string?

stSQL = "select Name from Physicians where Code = " & ID & " "
to (as an example)
stSQL = "select Name, Address, Phone from Physicians where Code = " & ID & " "

rylo

Yes. I have tried including all the fields, but get an error Method "Execute" of Command Object failed on the following line.. 'Set rs = cmd.Execute()".

I will need each field to go in a designated cell.

I tried to use your code and it seems to run fine.

Microsoft says the fast 'CopyFromRecordset' instruction will fail if the recordset
contains an OLE object field or array data such as hierarchical recordsets.

For more info: http://support.microsoft.com/kb/246335

Regards,
Antonio

ok.. i got it to work mostly. The error pops up when I use a field in the select statement that has "NULL" for some of its data.

Thanks