I am importing DBISAM data from an Excel-based office. There are not too many records,
about 10 tables, the largest of which contain 50,000 rows.

I have been using the following method:

Open Excel file in Open Office.
Save as CVS / TXT (comma delimited)
Run small Delphi program calling "ImportTable" exactly as per your useful technical article.

... however.

It seems that Open Office inserts some strange additional characters in the file which are
confusing the ImportTable process.

As I only have Notepad to view the files I can't see these additional characters.

--

Are there any utility programs anyone knows of which open text files and make these types
of non-visible characters visible?

If anyone out there has to do this type of work regularly ... is there any other advice??

Thanks in advance. Adam

Here is a FREE, great little notepad/editor replacement.  (written in
Delphi)

It has an integrated HEX editor, does just what you need.

http://www.pspad.com/


Walter

"adam" <adam@fullwellmill.co.uk> wrote in message
news:FF7923D6-508B-4FEB-92D1-4E2D9ECAAC91@news.elevatesoft.com...
>I am importing DBISAM data from an Excel-based office. There are not too
>many records,
> about 10 tables, the largest of which contain 50,000 rows.
>
> I have been using the following method:
>
> Open Excel file in Open Office.
> Save as CVS / TXT (comma delimited)
> Run small Delphi program calling "ImportTable" exactly as per your useful
> technical article.
>
> .. however.
>
> It seems that Open Office inserts some strange additional characters in
> the file which are
> confusing the ImportTable process.
>
> As I only have Notepad to view the files I can't see these additional
> characters.
>
> --
>
> Are there any utility programs anyone knows of which open text files and
> make these types
> of non-visible characters visible?
>
> If anyone out there has to do this type of work regularly ... is there any
> other advice??
>
> Thanks in advance. Adam
>

adam

Best advice I can give is to buy Mike Skolniks import software (www.scalabium.com) and stop having to go through OpenOffice at all. Its good code and not very expensive.


Roy Lambert

Thanks Roy & Walter, I was sure I had heard both of you mention these tools on the groups,
they both seem great.