If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
transfer data in access
I understand that the data in tables from Microsoft access can be transferred
to Microsoft Excel. However, I wonder if access allows you to tranfer data directly to other programs such as SPSS (statistical program). This program has some similarities with Excel, but they're not the same, and if this is possible, how can I do this? Miguel |
#2
|
|||
|
|||
transfer data in access
This is really a question for the SPSS developer. Access can export
data to an .xls file, .txt, .csv, .xml, and also ODBC compliant databases. Without knowing how SPSS can import the data, it is hard to say. Chris Nebinger |
#3
|
|||
|
|||
transfer data in access
Normally Statistics packages require 'denormalized data' whereas databases
store data in a 'normalized state'. The best bet is from access -- excel -- spss. I know spss will read and excel file directly, I'm not sure about a *.mdb file. You will need to look at the spss documentation. Some stats packages read dbI,II,III,IV files, so maybe they now will read access. As a statistician, I find I almost always need to take my data from a database using a query to pull out the data rows in the format I need them to process them in either SAS or Systat (I am not a user of SPSS). : Ed Warren. "Miguel Vivar" wrote in message ... I understand that the data in tables from Microsoft access can be transferred to Microsoft Excel. However, I wonder if access allows you to tranfer data directly to other programs such as SPSS (statistical program). This program has some similarities with Excel, but they're not the same, and if this is possible, how can I do this? Miguel |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date range on reports | Mark_Milly | Setting Up & Running Reports | 10 | January 19th, 2006 03:49 PM |
Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
Unable to have multiple queries feeding a single report | PZ Straube | Setting Up & Running Reports | 15 | June 15th, 2005 08:16 AM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 06:36 AM |