Hi all,
I have an PC application using MS Access 97 running on NT4.
Now, there is an upgrade to use internet technology.
I have to convert the MS Access 97 mdb file to become DB2 tables in
AIX.
Initially, I think of converting the Access to Excel then to CSV.
Then, FTP the CSV to AIX and import to DB2.
But, there are some memo fields in Access.
The longest memo field has 8000+ character.
The Excel cell can only accept 256 char.
Also, the memo fields are of multi-lines.
Such a multi-line may spoil the CSV file not able to be one-line-per-
record.
Is there any good / proper way to do it ?
Any opinions are welcome,
even using programming language (as long as it is not expensive)
Thanks
Alvin SIU
I have an PC application using MS Access 97 running on NT4.
Now, there is an upgrade to use internet technology.
I have to convert the MS Access 97 mdb file to become DB2 tables in
AIX.
Initially, I think of converting the Access to Excel then to CSV.
Then, FTP the CSV to AIX and import to DB2.
But, there are some memo fields in Access.
The longest memo field has 8000+ character.
The Excel cell can only accept 256 char.
Also, the memo fields are of multi-lines.
Such a multi-line may spoil the CSV file not able to be one-line-per-
record.
Is there any good / proper way to do it ?
Any opinions are welcome,
even using programming language (as long as it is not expensive)
Thanks
Alvin SIU