LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import from Database using field from excel. BD Excel Discussion (Misc queries) 1 May 10th 05 10:31 PM
How to stop excel from plotting a "blank" cell with formula as zer tiw Excel Discussion (Misc queries) 5 April 21st 05 08:38 PM
Excel file opens with a blank screen Meagan Excel Discussion (Misc queries) 1 April 18th 05 05:37 PM
?? Extra blank lines in 'address' cell after exporting to Excel Hadyn Pkok Excel Discussion (Misc queries) 4 April 15th 05 11:34 PM
On an import to excel a two digit date still is not right after c. Phillip Excel Discussion (Misc queries) 4 April 12th 05 04:30 PM


All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"