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
|