Page 1 of 1

Access Excel file and Fixed width file

Posted: Wed Oct 22, 2008 12:44 am
by deesh
Hi Friends,

How to access the Excel file (Source), May its like to import through sequencial file definition or some other plug-in side. Can explain to me.

How define the fixedwidth file, I have little bit doubt, Please explain this one also.

Posted: Wed Oct 22, 2008 8:07 am
by mail2hfz
Please do a search on the forum. This has been discussed many times before. Following links might help.
viewtopic.php?t=122195&highlight=excel+file

viewtopic.php?t=121586&highlight=excel+file

for fixed width file creation try to set the following.
Record Level Properties
Record length = fixed
Field defaults
Delimiter = none