Blank cells are Importing

[Sumanth.Ganjam]

Hi Everyone,



I has created a Macro to import the Material description from Excel to Database.

When running the Macro Material Description are Imported with Bank cells.

I don't know why Blank cells are also importing.

Please help me to import only data and not blank cells.

Thanks
Sumanth

[June7]

Are you saying there is data in the spreadsheet that is not being imported and get blank fields instead?

Want to provide the spreadsheet for analysis? Follow instructions at bottom of my post.

[Sumanth.Ganjam]

Hi,

Thanks for replaying, What is my Query is I am having excel with Data and when I am exporting to database from Excel I am getting the Data and even blank cells are also importing.My Question is why even Blank cells are also importing with data and in Database first blank Cell will be displayed and then Values will be displayed under Bank cell, i need to delete the Blank cell Manually.Through Macro I am Importing the excel to Database.

Thanks
Sumanth...

[June7]

In my experience, import of blank fields usually means there is empty string in the Excel cell. Again, if you want to provide ...