Pipe-delimited files to Excel or Access

[cbres00]

Does anyone know of a way I
can automate the process of importing a pipe-delimited file into an Excel or Access
database? TIA, Cathy Breslow

[RikTytgat]

Hi,

If you know some perl. There is a perl module that can be used to write excel format:

http://search.cpan.org/search?mode=module&query=excel

will list the existing modules.

Hope this helps,
Rik.

[cbres00]

It says "get information from Excel file." I wanted to import INTO an Excel file.
Is this the same?
Cathy

[RikTytgat · Accepted solution]

Cathy,

If you scroll down a little further on the URL I gave in previous post, you can see the module

Spreadsheet::WriteExcel?-?Write to a cross-platform Excel binary file.

This can be used to write an excel file.

Bye,
Rik

[Charles McCary]

Cathy,

Here's how I've done it:

1) save file as .csv
2) enter the following command to mail it to your desktop:

uuencode filename.csv filename.csv | mailx -s "test file" your_email@your_domain.com

If using Microsoft Outlook, you should then receive an attachment that will open into excel automatically, you can then delimit based on |


- OR -

before mailing to yourself, change all pipes to , (which is what a csv file really is, comma delimited file). Then it will automatically size the fields based on where the , are placed. I realize you may not be able to do this because you have commas in your data.

Anyway - hope this helps.

C

[cbres00]

Great answers! I'll try both!
Many thanks,
Cathy