ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   extracting contact info to a database (https://www.excelbanter.com/excel-discussion-misc-queries/3917-extracting-contact-info-database.html)

gordie

extracting contact info to a database
 
can anyone tell me how to extract contact management information from excel
to export to act 2004

Dave Peterson

I don't use ACT, but until you get a better answer, have you looked under ACT's
file menu.

Is there an Import option?
If yes, does that support *.xls files.

Heck, does ACT allow File|open of *.xls files directly?

If it doesn't, you may want to look for .CSV files in ACT's import routine (or
File|open).

Excel allows you to save each sheet in a workbook as a .CSV (comma separated
values). If ACT can import that, you're almost done.



gordie wrote:

can anyone tell me how to extract contact management information from excel
to export to act 2004


--

Dave Peterson


All times are GMT +1. The time now is 07:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com