Wednesday, March 28, 2012

put delimited data in unconventional format in dataset

hi,

Im interfacing with an app that imports/exports data in a very specific hash-delimited format
like this:

#column1=Value1#column2=Value2#column3=Value3 etc.

How do i import this into a dataset so i can in my db.

Obviously ideal way would be to use the Jet text provider, but im not sure if the schema.ini can be setup to deal with this kind of data.

If anyone has ANY way of me getting this data into dataset please help.Have you can access to SQL DTS?

No comments:

Post a Comment