a) How do I create an Excel compatible file from a delimited text file ?
Use commas to delimit and save as a .csv file. Excel will recognise this as a comma delimited file and open and format correctly.
 
b) Should I be copying some sort of database file instead ?
Don't know. Do you want to access by key or use SQL to manipulate? Excel can open .dbf files - some versions will open Paradox files
 
HTH
Mike
----- Original Message -----
Sent: Saturday, August 18, 2001 12:42 PM
Subject: [DUG]: Excel files

Guidance please.

I need to be able to create a (probably text) "Master" file and append data to it from time to time from a Delphi application.On occassions an operator will need to asyncronously access this file and use Excel to manipulate and display the current data as they choose.

 I'm hoping to have this process initiated within my application, firstly creating an Excel compatible (*.xls) copy of the "Master" text file thus ensuring that the original isn't used and maybe altered in some way, then calling Excel. I want the file import to be transparent to the user (no hastle with wizards) hence the need for compatability.

My questions are :-

    a) How do I create an Excel compatible file from a delimited text file ?

    b) Should I be copying some sort of database file instead ?

TIA

Colin

Colin R Dillicar
Automation Engineering Ltd
Auckland  New Zealand
[EMAIL PROTECTED]
Ph +64(9)571-0073  Fx +64(9)571-0377

Reply via email to