I created a csv text file using FSO and loaded comma delimeter records from the db. After that I opened csv file using exel. Than insert a column and appended some more data. The problem is it's not saving the newly added data. When I open the csv file, it's opening in READ-ONLY mode. Why? After I insert a column and data how do I store it? Thanks in advance.
28-08-2004 at 01:32 PM
|
Goran Level: Moderator Registered: 16-05-2002 Posts: 1681
Re: CSV and xls files
Are you saying that your csv file has Read-Only attribute? If so, you can remove it using API's, like SetFileAttributes
____________________________
If you find the answer helpful, please mark this topic as solved.
31-08-2004 at 01:13 AM
|
pavane Level: VB Lord Registered: 26-04-2004 Posts: 179
Re: CSV and xls files
Are you by any chance using Win2000?
Sometimes it seems to keep hold of a file even after you have closed it in your code (But didn't close the application itself)
I had this problem when writing temporary MIDI files - in WIN2000, I could not just overwrite the previous version.
It works OK in other WIN versions.