Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
You can share the workbook with the ones who needs to make a change by
Protecting your Workbook by choosing a common password......Go to TOOLS---PROTECTION----PROTECT SHEET....When you are here you can also select the ALLOW USERS TO EDIT CHNAGES to specifically allow some range of cells. After that you can select the stuff you want others to do on that worksheet....Also before protecting the workbook you can go to FORMAT---CELLS and lock or unlock stuff...... Hope it will help...I never tried but read that on this Forum "vgurusa" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import from Database using field from excel. | Excel Discussion (Misc queries) | |||
How to stop excel from plotting a "blank" cell with formula as zer | Excel Discussion (Misc queries) | |||
Excel file opens with a blank screen | Excel Discussion (Misc queries) | |||
?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) | |||
On an import to excel a two digit date still is not right after c. | Excel Discussion (Misc queries) |