Democratic Underground Latest Greatest Lobby Journals Search Options Help Login
Google

Convert XCEL(or Works) spreadsheet to ACT! database??

Printer-friendly format Printer-friendly format
Printer-friendly format Email this thread to a friend
Printer-friendly format Bookmark this thread
This topic is archived.
Home » Discuss » DU Groups » Computers & Internet » Computer Help and Support Group Donate to DU
 
Capn Sunshine Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jan-23-06 05:23 PM
Original message
Convert XCEL(or Works) spreadsheet to ACT! database??
Is this possible? It seems like it would be, but damned if I can figure it out.
Printer Friendly | Permalink |  | Top
Angry Girl Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jan-23-06 07:53 PM
Response to Original message
1. Doesn't ACT understand CSV? Try this....
http://8help.osu.edu/1701.html

CSV stands for Comma Separated Values, sometimes also called Comma Delimited. A CSV file is a specially formatted plain text file which stores spreadsheet or basic database-style information in a very simple format, with one record on each line, and each field within that record separated by a comma. It's important that the individual "records" within a CSV file NOT contain commas, as this may break the simple formatting when using the file in another application.

CSV files are often used as a simple way to transfer a large volume of spreadsheet or database information between programs, without worring about special file types. For example, transferring a home-made address book from Excel into a database program such as Filemaker Pro could be done by exporting the file as a CSV from Excel, then importing that CSV into Filemaker.

Creating a CSV file from spreadsheet data is very simple to do using Microsoft Excel.
CONTINUED...
http://8help.osu.edu/1701.html
Printer Friendly | Permalink |  | Top
 
Capn Sunshine Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jan-23-06 09:02 PM
Response to Reply #1
2. Thanks for this, it may be the answer
I think all I have to do is convert the Works spreadsheet back to Excel, and do it from there?

Stay Tuned.

Printer Friendly | Permalink |  | Top
 
Capn Sunshine Donating Member (1000+ posts) Send PM | Profile | Ignore Mon Jan-30-06 02:37 PM
Response to Reply #2
3. That was it--
Thanks
Printer Friendly | Permalink |  | Top
 
DU AdBot (1000+ posts) Click to send private message to this author Click to view 
this author's profile Click to add 
this author to your buddy list Click to add 
this author to your Ignore list Thu Apr 25th 2024, 11:14 AM
Response to Original message
Advertisements [?]
 Top

Home » Discuss » DU Groups » Computers & Internet » Computer Help and Support Group Donate to DU

Powered by DCForum+ Version 1.1 Copyright 1997-2002 DCScripts.com
Software has been extensively modified by the DU administrators


Important Notices: By participating on this discussion board, visitors agree to abide by the rules outlined on our Rules page. Messages posted on the Democratic Underground Discussion Forums are the opinions of the individuals who post them, and do not necessarily represent the opinions of Democratic Underground, LLC.

Home  |  Discussion Forums  |  Journals |  Store  |  Donate

About DU  |  Contact Us  |  Privacy Policy

Got a message for Democratic Underground? Click here to send us a message.

© 2001 - 2011 Democratic Underground, LLC