Click here to Skip to main content
16,012,843 members

Comments by Amol Lendave (Top 12 by date)

Amol Lendave 16-Jul-15 3:44am View    
Thanks for quick response.

Can we do same using OpenOffice or any another option it should be open source.
Actually I'm not using MSOffice
Amol Lendave 18-May-15 6:52am View    
It me possible that column name is "A.B" at that time what i should do.

Columns are not fixed.
Amol Lendave 18-May-15 6:42am View    
Mean while i have created some changes that works me.

Added
Extended Properties=\"Excel 12.0;HDR=No;IMEX=1\"
into connection string.

"HDR=No and IMEX=1" will avoid conversion of First row to Columns.

After that i have converted first row to columns and 2nd to nth rows as table Rows.

This is not proper solution. but it works me fine.
Amol Lendave 18-May-15 6:00am View    
It's not feasible to replace # to ., if my column name is "C# .Net" it will convert into "C# #Net".
After # to . replacement "C. .Net" not acceptable any more.
Amol Lendave 18-May-15 5:52am View    
For .xls "Microsoft.Jet.OLEDB.4.0"
and for .xlsx "Microsoft.ACE.OLEDB.12.0"

for .xls = Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"
and for .xlsx = Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1\"