At 03:32 PM 11/8/2010, Luc Delcoigne wrote:
I have begun to convert the data of my access database to RBase.
in an Access table I have a date column in the format DD/MM/YYYY.
When I import this table with the File Gateway, I get a format
MM/DD/YYYY in the Rbase table for that same column, meaning that
all dates higher than de 12th of a month are not imported as Rbase
thinks it is month 13 where it should read day 13.
What am I overlooking here ?
Luc,
Without knowing all details, including settings of your database ...
Did you know that you can use the "ODBC Migration" approach to easily
migrate/import data from any ODBC compliant database, such as MS SQL,
Oracle, DB2, including MS Access?
Having worked with R:BASE eXtreme 9.0 (64), you should take advantage
of such functionality.
Here's how:
Define a System DSN for Access database using MS Access Driver (*.mdb).
After CONNECTing your R:BASE eXtreme 9.0 database, you may either use
the menu-driven approach to CONNECT SQL Data Source ... and then Attach
SQL Database Tables, as follows:
Database Explorer | Main Menu | Utilities | Connect SQL Data Source ...
Database Explorer | Main Menu | Utilities | Attach SQL Database Tables
OR use SCONNECT and then SATTACH commands to bring in all tables as
"server tables" in R:BASE.
Once those tables are attached, you may COPY these tables as permanent
R:BASE tables, or PROJECT them as TEMPORARY tables to achieve your goal.
Very Best R:egards,
Razzak.
P.S.
You may take a look at the "Integrating R:BASE eXtreme 9.0 (64) with
ODBC Compliant Databases, such as Oracle, MS SQL Server" application
that illustrates the steps and approach to achieve your goal.
http://www.rbase.com/cp/
