TransferText from a REPORT (1 Viewer)

JEB

Registered User.
Local time
Today, 03:15
Joined
Dec 20, 2002
Messages
16
Ok - I'm new to VBA so bear with me

I have a REPORT that I need to export in a Tab delimited format.

The report has header rows and detail rows - starting with H and D respectivly.

As I have searched and tried to use:

DoCmd.transfertext acExportdelim, ,REPORT,C:\REPORT.txt

Everything talks about either TABLES or QUERIES. Can I use this type of command for Reports - are there any changes?

So far I have been umable to make it work and it hangs Acess.

Also - is this a Tab delimited format - or is some other delimiter used?

Thanks,
Jeb
 
The report is going to be bound to a table and/or query. Can you not just export that instead?

If not, you can't really output a report as a text delimited file. You can output it as straight text (See DoCmd.OutputTo for how to do this), but it's sloppy. You can output a report in to Excel format (see the same DoCmd from the last sentence), which can then go into a CSV or delimited format. Keep in mind again, though, this is going to produce some weird results.

I'm not clear why you would want a delimited file out of a report, much less why the record source for that report wouldn't be used as that would be easy to output in a delimited format.
 
I pull data from 2 linked SQL Databases. The information includes header information and detail information from invoices.

Header information is due date, terms, ship to, etc.
Detail information is individual items shipped

I then need a report that combimes the has a these by invoice IE:

INV Due Date Terms PO# Total
H 123 01/01/07 1% 567 $180.00

D 3 EA Widget1 $10.00 EA $ 30.00
D 10 EA Things $15.00 EA $150.00

H Lines = Header Info
D Lines = Detail
END

I then need to get this to a vendor in an exact tab delimited format for
payment and have the word end at the bottom of my report.

I don't see how to create a query that will produce information in this form

Any suggestions?

Thanks
 

Users who are viewing this thread

Back
Top Bottom