All:
Rbase 9.5(64) Single User, Win 7 Summary: a) The GATEWAY command at the R>Prompt fails completely to draw data into the target table; b) The GATEWAY tool, with or without a specification, loads everything correctly with the exception of the AUTONUM column, which populates with NULLs. I have a simple table with an autonum column: List table opcashbalance Cashbalid integer not null autonumber Cashdate date Cashbal currency Cashavg currency Cashdelta currency Cashmin currency With an XLSX (single worksheet) source file, the following command fails to draw data in: GATEWAY IMPORT XLS d:\00\gway\gway_opcashbalance.xlsx + APPEND opcashbalance + OPTION AUTONUM ON + |FIRST_ROW 2 When the XLSX file is saved as CSV, the following command fails to draw data in: GATEWAY IMPORT CSV d:\00\gway\gway_opcashbalance.csv + APPEND opcashbalance + OPTION AUTONUM ON + |FIRST_ROW 2 When the process is worked through the GATEWAY tool, everything imports except the AUTONUM column, which populates with NULLs. Am I missing something here, or should I generate the autonum value in the source file and learn to love the LOAD command? Thanks Bruce Chitiea SafeSectors, Inc. eCondoMetrics
