answersLogoWhite

0

Use the import function and select the spreadsheet you wish to bring in. You can create a new table in Access, or you can make sure the column headings match up and bring it into existing tables.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

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.


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


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.


Can you export information from Excel into Access?

Yes, but you would use the Access import option, instead of an Excel export option. You also can use Excel to SaveAs various formats that Access could import, but direct import from Access probably would be the most efficient method. See related links for various options for sharing data between Excel and Access.


How do you export data from PRMS to Microsoft Excel?

You Can't


When importing an access database table Excel does what?

It will put the fields in Access into columns in Excel, and records in Access will be in rows in Excel. Data will be converted to appropriate data types.


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.


Which methods can you use to export data from access 2007?

Export to XML. Export to another Access database. Export to HTML.


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.


Data can be imported into one Access database from another Access database?

If you are asking whether it is possible, then yes. One method would be to export the data from the first into a comma-separated file, Excel workbook or the like, then import into the second.


How can you convert an Access database to an Excel spreadsheet?

To export the Access database to an Excel sheet in an easy way and for a detailed explanation, see the related links.