Export single record to a single xls file.

[sicSRT8]

Is it possible to set a script to export a record based on fields in a table to an existing .xls file with previous records? That way when inventory adjustments are made it wont update previous records.

I don't want multiple .xls files. I want the specified fields to go to one.xls file and list in rows within the specified fields the data contained in them.

So once I'm done creating a record from drops downs and calculations I can send the info to my .xls file in rows of records. Hope that makes sense.

I guess what im trying to find out is how to export a single record to a xls file

Edited April 8, 2009 by Guest

[mr_vodka]

Not directly. Although you probably could import the xls file into a temp table, add the record(s) that you want to it and then export out again.

[sicSRT8]

Wouldnt that have the same effect as just exporting?