Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Loading Access 2007 from Excell
Hello,
I am loading an Access 2007 from an Excell datasheet... After loading one of the tables on this Access DB when I read some of the rows from the loaded table thru a Visual Basic 2005 application, I get DBNull abend at the time of reading the row and transfering the data to a UserForm... How can I prevent this situation through Access column parameters or some other means at the load time? -- Jeff B Paarsa -- Jeff B Paarsa |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Loading Access 2007 from Excell
Some of the data you are loading relate to key fields that are set to cannot
be empty (null). You need to make sure that the data you are loading does not contain blank rows. This generally occurs when you load data from another application like a manufacturing or accounting system. -- Hope this helps Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK Please do not forget to rate this reply. "Jeffery B Paarsa" wrote: Hello, I am loading an Access 2007 from an Excell datasheet... After loading one of the tables on this Access DB when I read some of the rows from the loaded table thru a Visual Basic 2005 application, I get DBNull abend at the time of reading the row and transfering the data to a UserForm... How can I prevent this situation through Access column parameters or some other means at the load time? -- Jeff B Paarsa -- Jeff B Paarsa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toolbar built for 2003 not loading in 2007 | Excel Worksheet Functions | |||
Loading File in Excel 2007 | Excel Discussion (Misc queries) | |||
Excell 2007 adding to the Quick Access bar | Setting up and Configuration of Excel | |||
loading PHStat2 in excel 2007 | Setting up and Configuration of Excel | |||
loading data from access in vba | New Users to Excel |