View Single Post
  #1   Report Post  
vgurusa
 
Posts: n/a
Default Excel Blank Value Import


Hi ,

I am trying to import Excel File to MS Access using Visual Basic.

The problem I encountered is as follows :

When I import an excel file, if the first row of an excel file contains
an empty cell then thereafter the data in that particular column doesn't
get imported!

I am using OLEDBJET 4.0 to connect and retrieve the data from Excel
Sheet.

It would be great, if anybody can post their thoughts on it!

Thanks,

Vijay


--
vgurusa
------------------------------------------------------------------------
vgurusa's Profile: http://www.excelforum.com/member.php...o&userid=28100
View this thread: http://www.excelforum.com/showthread...hreadid=476067