using schema.ini to write to file

[Jim Heimer]

Hi,

I've been using schema.ini to read an ascii file to a dataset. Would it be
possible to write to the ascii file the same way I read from it? In my case,
the initial ascii file has two "columns" readable by schema.ini, first name
and last name. After the process, I need to write the emplcode to that same
file. In schema.ini, Would it be possible to add an additional "column"
called emplcode (that does not contain any data in the initial ascii file)
and update each row of the file with an update query or would I need to
write the file normally using the Streamwriter methods?

Thanks,
Jim

 

[Jeffrey Tan[MSFT]]

Hi Jim,

Based on my understanding, you have read from a text file through ADO.net
and Schema.ini file, then you want to write a text file with a update.

ADO.net only expose the function of reading text file through .ini file
through ODBC or OLEDB Text Provider. Because text file is a loosely
structed, there is not a build-in way to update it or add record to it.

Normally, text file is for read only purpose. If you really want to do
this, you have to write it like a normal text file through TextWriter.

I recommanded you to use XML file or access(.mdb) file or even Excel file
to replace text file. For these files, ADO.net has strong function to
manipulate it.

===============================
Please apply my suggestion above and let me know if it helps resolve your
problem.

Thank you for your patience and cooperation. If you have any questions or
concerns, please feel free to post it in the group. I am standing by to be
of assistance.

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 

[Jeffrey Tan[MSFT]]

Hi Jim,

Does my reply makes sense to you? Do you still have any concern?

Please feel free to let me know, I will help you. Thanks

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 

[Jim Heimer]

Thanks for the reply. I had a feeling it couldn't be done. I just wanted to
make sure with you guys first.

Thanks again,
Jim

 

[Jeffrey Tan[MSFT]]

Hi Jim,

Thanks very much for your feedback.

I am glad my reply makes sense to you. If you need further help, please
feel free to post, I will help you. Thanks

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.