Export a form's records to an Excel spreadsheet

  • Thread starter Thread starter Patrick386
  • Start date Start date
P

Patrick386

Hello!
Is it possible to export a the content of a continuous form that is linked to a recordsource directly to Excel? to have the same result as File menu, Print Preview. Tools menu, Office Links, Analyze it with Microsoft Excel.

I have tried this but it does export to an Excel file, but it is attached to an email :(

Docmd.SendObject AcSendForm, Me.Name, acFormatXLS

Thanks for your help!
 
Hello!
Is it possible to export a the content of a continuous form that is linked to a recordsource directly to Excel? to have the same result as File menu, Print Preview. Tools menu, Office Links, Analyze it with Microsoft Excel.

I have tried this but it does export to an Excel file, but it is attached to an email :(

Docmd.SendObject AcSendForm, Me.Name, acFormatXLS

Thanks for your help!
Click to expand...

Use TransferSpreadsheet( ) to create an excel file from a recordset,
and then RunApp to start Excel.
 
Not directly. You will need to create a query that will return the same
records as the form's recordset and export it that way.
 
Cool, didn't know this one..
the only thing that I cannot do with this function is to put an select sql
statement int the argument "TableName"

Thanks again for your help. I will see if I really need that I create an
Excel object to do it

Best regards
 
Cool, didn't know this one..
the only thing that I cannot do with this function is to put an select sql
statement int the argument "TableName"

Thanks again for your help. I will see if I really need that I create an
Excel object to do it

Best regards

"OldPro" <[email protected]> a écrit dans le message de (e-mail address removed)...





- Show quoted text -
Click to expand...

Yeah, you need to use an INSERT INTO to copy a recordset into a
temporary table first...
 
you *can* export a query to

Pieter

Cool, didn't know this one..
the only thing that I cannot do with this function is to put an select sql
statement int the argument "TableName"

Thanks again for your help. I will see if I really need that I create an
Excel object to do it

Best regards

"OldPro" <[email protected]> a écrit dans le message de (e-mail address removed)...





- Show quoted text -
Click to expand...

Yeah, you need to use an INSERT INTO to copy a recordset into a
temporary table first...
 
Great thanks for all your help!
after all, I'll use

Docmd.OutputTo ...

I'll only need to create a temporary QueryDef object, export and than erase
the query def. Plus this function ask the user where to store the file if
omitted. so I won't need to take care of it

Cool


"Pieter Wijnen"
 
Back
Top