ADODB Drivers for CSV & XLSX

[Shreedhar]

Hi Gurus,
I am Currently using different ADODB drivers to read data from XLSX, CSV files, Are there any drivers that supports both CSV and XLSX type of files.

Thanks for your time.

Much Appreciated.

Thanks and Regards,
Shreedhar

 

[Debaser]

ACE OLEDB will read both.

 

[Shreedhar]

ACE OLEDB will read both.

Thanks Debaser...I'll try using ACE and keep you posted.

 

[Shreedhar]

ACE OLEDB will read both.

I am unable to use Replace function, are restriction on using functions like Replace in SQL query with ACE OLEDB driver.

Kindly suggest how to overcome this limitation.

Thanks..

 

[Debaser]

It should work - what is your code?

 

[Shreedhar]

It should work - what is your code?

Sorry about the delayed response. The issue was due to not closing the previous ADODB connection. Once I closed it & opened new connection with ACE OLEDB it worked.

strSQL = " SELECT distinct replace(replace([a.email], '@YAHOO.COM', ''), '.', ' ') from [DAST_MEMBER$] a, [BEEHIVE$] b where a.email = b.email and a.email is not null"

Thanks Debaser..

 

[Debaser]

You're welcome.