0
Create the report in a tab delimited format. It may have a suffix like txt or rpt. In Excel use the "Open" command. You will get a panel that allows you to refine where the column breaks are and define the format of the columns. Once this is done the data will be in Excel. Just save as a standard Excel file.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
How do you export stream data to excel file from HySYS?
There is something called a workbook dump. It is excel-based, and can be used to export data from HySYS to excel.
You can export to Excel but you cannot export data to a text file?
The answer is: False
How do you export data from PRMS to Microsoft Excel?
You Can't
What is used for importing data into Excel that is stored on the website?
A web query.
How do you extract a data in Microsoft Excel?
Not sure if you want to know how to export data from Excel or import data into Excel. Either way, the answer depends on what you are trying to do. You can export data from Excel by using the SaveAs option to save the file in a format you choose. If you are trying to use another program to extract data from Excel, you will need to use the options available to that specific program.
Is it true that you can export to Excel but you cannot export data to a text file?
The answer to this question would depend on the source you are exporting. You can export data from Excel to a text file in a variety of formats. Just Save As and select the format you prefer.
When you data from Access to Excel a copy of the data is created in Excel?
You can copy data from Access and paste it directly into Excel. From a table or query, data can be selected and then copied and pasted into Excel. In that case, data changing in the original Access file will not change data in the Excel file. To do that there must be a link between the data. You can also import data from Access into Excel and from Excel into Access, again maintaining a link to the source if you want.
What options do you have in mainframe ADABAS to explore data directly or extract or export data to an Excel spreadsheet?
I am not sure of options within ADABAS to export data directly to excel. But using a programing language (eg: Natural) mainframe ADABAS data can be read and then ConnectDirected to excel. Please revert in case of any details qureies
How do you export data from a Dos ver 5 database to Excel?
A good way is to export from a database is to save as CSV format (or some sort of comma-delimited text format), then open Excel and import the file into Excel.
How do you export data from Notepad to Excel?
You can open a Notepad document direct in Excel. If it has been saved as a CSV file, then the data will come in separated into cells in Excel, where commas occur in the document. Each new line of data in the Notepad document will appear on a new row in Excel.
Can VCard data be imported into Excel?
Yes. You need to export it from your email or contacts program to a Comma Separated Value format, which Excel can then open directly.
Can you transfer files from filemaker pro to access 2007?
yes, export data as excel data from filemaker pro, and then import this one into access.
