EXCEL AND ACT!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HOW DO I MERGE EXCEL AND ACT FILES? I WANT TO MERGE AN EXCEL FILE INTO MY
ACT! PROGRAM
 
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
 
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.
 
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]...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail merge in Excel 1
Export excel to ACT 1
How do i import from ACT! to Excel? 2
merge two rows 5
Why does the "/" key act like the alt key 2
Modifying Data 1
Sumif want to sum a range bigger than one column 3
Mail Merge (Excel to Excel) 1

Back
Top