Computers & Internet Logo
Posted on Jan 05, 2009
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

Input data I have just bought and installed the sage instant accounts package. I have done the initial setup. Before using Sage I previously did my bookkeeping on MS Excel. Is there any way of transferring that data from Excel into Sage without having to input all the information manually?

  • FA Jan 05, 2009

    After doing this, how can i copy this data into the sage accounts software without typing in each figure etc.?

×

1 Answer

Milind Shetti

Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Guru:

An expert who has written 7 tips or uploaded 3 video tips

  • Master 829 Answers
  • Posted on Jan 05, 2009
Milind Shetti
Master
Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Guru:

An expert who has written 7 tips or uploaded 3 video tips

Joined: Dec 14, 2008
Answers
829
Questions
0
Helped
386176
Points
2380

If you want to transfer your data into SAS, SPSS, or some other program, follow these guidelines:
The cells in Row 1 should contain the column's eventual data set name. Each name should be a relatively short and unique acronym that clearly identifies the data. It should begin with a letter and contain only letters, numbers, or an underscore ( _ ) where spaces would naturally fall. Avoid using special characters such as $, &, @, in variable names. Since each row represents the values from one subject, the first column(s) should contain one or more variables that give each subject a unique identifier. They become especially important if you need to merge two or more data files.
In Excel, data formats are defined for a range of cells rather than for a complete column. For this reason it is important that each entire column, including cells with missing or uncollected data, have one, and only one, format. Actually, you do not need to format the entire column, only the portion you will eventually use. Highlight that portion and select the appropriate format from the Format/Cells option. Do not select formats that will enter commas, dollar signs, or other visual enhancements. Numeric, text, and date formats (e.g. mm/dd/yy is often a good choice) are probably the only formats you'll ever need.
The "Split" option (under the "Window" pull-down menu) keeps the row of variable names and the columns of identifiers in view, whatever range of cells in the worksheet you may need to review. First place the cursor at the most extreme upper left-hand corner where data entry begins (e.g., the intersection of Row 2 and the column in the upper left-hand corner where data appear) and then select "Split" from this menu. For any row or column of the worksheet you move to, you'll know exactly which variables you are observing (column names) and their associated ID values (rows).
For versions of Excel later than 4.0, one file can contain multiple worksheets. By default, the tabs at the bottom of these sheets are supplied names ("sheet1," "sheet2," etc.). You can change these names by clicking this space with your mouse and entering a new name. Use the same conventions for first-row variable names: use a short acronym of the page contents that begins with a letter, use only letters or numbers, and enter the underscore ( _ ) where a space naturally falls.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

247 views

Ask a Question

Usually answered in minutes!

Top Sage Computers & Internet Experts

vince

Level 3 Expert

2544 Answers

john h

Level 3 Expert

29497 Answers

Arnie Burke
Arnie Burke

Level 3 Expert

7373 Answers

Are you a Sage Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...