Export only Modified Records

Y

yovation

Hello,

I have a .txt file with 17,000 records. When I update/modify one or
two records, I would like to export the updated/modified records into
a new .txt file that i can upload to my online store.

Is that possible?

What I am trying to accomplish is keeping an offline database of
inventory I have in my online store. There is no need to update the
entire .txt file if I only need to change one or two records. Perhaps
there is an easier way. I don't want to 'link' to the online file. I
want the data I am working on completely off line.

thank you.
David
 
D

Don Guillett

You could use a worksheet_change event that copies that row to a new sheet
next available row and then save that sheet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Table Records to txt file 1
Extract DB2 data to text files 1
Export to txt file using VBA 1
Access User Login form in Access with Ristriction 0
Export table to txt file with a variable filename 0
Writing records to CSV file 10
Macro that will insert a simple text string in top cell of text file 1
Append Records to a Text File 6

Top