E
EXCEL AND ACT!
HOW DO I MERGE EXCEL AND ACT FILES? I WANT TO MERGE AN EXCEL FILE INTO MY
ACT! PROGRAM
ACT! PROGRAM
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
psasales
Save your EXCEL document as a text (tab delimited) file. Open Act! and
import data then select tab delimited you will be given the option of
directing the information in your file to the appropriate fields in ACT! If
your spread sheat heading match Act this is nearly automatic
import data then select tab delimited you will be given the option of
directing the information in your file to the appropriate fields in ACT! If
your spread sheat heading match Act this is nearly automatic
T
TomHinkle
ACT! should be able to read an excel file directly, provided you have the
data organized in a table.
If not you need to export data to a standard format.. I like CSV personally,
but text, csv, tab delimited should all work.
Any way you slice it, you WILL have to go through a mapping exercise in ACT!
to tell it what fields in ACT! map to columns in Excel.
data organized in a table.
If not you need to export data to a standard format.. I like CSV personally,
but text, csv, tab delimited should all work.
Any way you slice it, you WILL have to go through a mapping exercise in ACT!
to tell it what fields in ACT! map to columns in Excel.
C
Chip Pearson
Excel has no support for Act files. You need to export your data
from Act in to a format that Excel can recognize, such as xls,
csv, txt, sylk, or something.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
in message
news:[email protected]...
from Act in to a format that Excel can recognize, such as xls,
csv, txt, sylk, or something.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
in message
news:[email protected]...