Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can CrossData/400 import Excel CSV files to my AS/400 database?

April 26, 2017crossdata csv database Excel files import

0

Posted

Can CrossData/400 import Excel CSV files to my AS/400 database?

1 Answer

0

Posted

Yes! CrossData/400 can read a file in CSV or tab-delimited format and add the data to your AS/400 DB2/400 database files. CrossData/400 performs numeric conversions for zoned, packed, binary and floating point data. In addition it can convert date and time data to date and time fields in your database. No special mapping is required CrossData/400 will read the external description of your database file and map the CSV data to your file.