On 2002-05-09 06:41, Ian Mac wrote:
On 2002-05-09 05:23, Aaron wrote:
What version of Excel are you using?
This message was edited by Mark W. on 2002-05-08 15:09
Excel 97
Type Query in the Help files and should get you started.
this is one part but without the extra buttons for help:
Get external data by using the Query Wizard
1 Click the cell where you want to start the external data range.
2 On the Data menu, point to Get External Data, and then click Create New Query.
3 On the Databases tab, select the database from which you want to retrieve the data.
If you need to set up a new data source, double-click New Data Source, and then specify the data source.
How?
4 Make sure the Use the Query Wizard to create/edit queries check box is selected, and then click OK.
5 Follow the instructions in the Query Wizard.
6 To return the data directly to Microsoft Excel, click Return Data to Microsoft Excel, click Finish, and then select where you want to put the external data.
How?
To refine the query further, click View data or edit query in Microsoft Query, click Finish, and then make the changes you want. For more information about refining the results of a query, see Microsoft Query Help.
If you choose to refine the query further in Microsoft Query, the result set is displayed in Microsoft Query. If you want, you can return the result set to Microsoft Excel at a later time.
Notes
· You can check the status of a query that's running in the background and taking a long time to return data. While the query is executing, click Refresh Status on the External Data toolbar. To cancel the query, click Stop Refresh.
· For information about the kinds of queries you can create with the Query Wizard, click .
[/quote]
The only problem is that I can only download data that doesn't apply to Excel I think. Everytime I try to do get external data it gives me a read only error message. The extension of my file is .prn just a normal text file.