Export to file

[John]

I have data in a table SALES that I want to export to an individual file for each customer WHERE (((SALES.Packed)=No));

The file will be named CUSTOMERID.qqq - both are fields in the table

The data to be put in the file is from the Job_Order field and I wouldlike it per line as there may be 2-5 entries for that customer

Many thanks

[Access Guy]

Hi John

Couple of questions to verify.

So one file per customer, and one line per record for that customer?

Do you want a CSV type file?

Are you familiar with writing code?

Is this a once off thing, or something to be used regularly?

[John]

yes one file per customer containg the record for that customer that are not packed

A csv type file would do the job as long as it had a .qqq extension

I am not that familiar with writing code

It will be used daily, I have a query that prints labels for the customers and a query that then updates all sales to packed, these are run manually

Thanks

[Access Guy]

Without writing code, and I think that is more difficult than I can explain here, have you considered just using the File > Export option.

You would need to parameter create a query that gets the data into the format you want for the file, then user File > Export to export to a CSV file. You would need to do this manually, or maybe a macro, and supply the filename manually.

So create a query that lists all the data you want, add a parameter for selecting the customer, then choose CSV as the export format and follow the Export wizard.

Other than that if you want to delve into code the first thing is to get familiar with basic code and then look at the TransferText action/method to do the export. Or if you know someone who can write code.

Maybe someone else here can provide more information. Try contacting some of the developers here with more experience.