At 11:11 AM 5/24/2013, Bruce A. Chitiea wrote:
Razzak:
Thank you very much for the exercises.
My SHOW ZERO shows "ON"
I've performed a set of controlled experiments with a set of source files:
Opcashbalance.xlsx
Opcashbalance.xls
Opcashbalance.csv
... generated from Excel 2013
... containing only one worksheet
... with blank column 1 to accommodate the CASHBALID autonumber column
... with data starting on row 1
... sourced sequentially from each two folders:
D:\00\gway
<database folder>
... with your exercise code appropriately modified
both exercises 01.RMD and 02.RMD fail to import data.
The import dialog appears and is immediately overlain by a constraint error
message:
"Value for Column CashBalID Cannot be NULL" [OK]
"Value for Column CashBalID Cannot be NULL" [OK]
"No rows in table, INSERT a NULL row? [NO]
There may be more clues, but through the blue, hard to view.
Thoughts? And thanks.
Bruce,
My schedule and time permitting, I will send you my test files that were
created to illustrate the proper method, as posted in my original reply.
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
