Open an Excel File using OLEDB with Formatting

[vbkris]

Hi Guys,

I am currently working on a "Bulk Upload" page that will read data from a manually prepared Excel file.

I was using the OLEDB approach till now for this.

However a new requirement has come up that will involve having an extra column in the excel sheet that has "HTML links" as its data.

The current code just returns the text of the link but not the actual link which i need.

Is there a way i can overcome this and still retain the OLEDB approach?

Krishnan

Known is handfull, Unknown is worldfull

 

[jbenson001]

The current code just returns the text of the link but not the actual link which i need.

Can't help you with out seeing the code.

 

[jmeckley]

oeldb treats the spreadsheet as a database table. if you need meta data about the field (in this case the link opposed to the text) then you need to treat the datasource as an excel workbook/worksheets and parse the data.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[vbkris]

hi,

i found a workaround for this

I added a hidden column in the Excel sheet and used a Macro in that sheet to extract the link out. So now i read this hidden column directly in my query and get the data out.

Krishnan

Known is handfull, Unknown is worldfull