Removing Data Tables formed from importing data from Access

A

Andrea Jones

If you use the 'From Access' button in the Data ribbon in Excel 2007 to
import a table from an Access database it is automatically formatted as a
Data Table. If you then use the 'Convert to Range' button to remove the Data
Table functionality you also lose your import data connection. Does anyone
know whether it is possible to stop imported Access data being formatted as a
data table (apart from exporting from Access to .txt and then importing)?

Andrea Jones
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Get Filtered Data from SQL server into Microsoft Excel 2007 5
Unwanted formatting with imported data 1
Need to stop automatic column re-sizing when importing XML data 0
Import data, fill adjacent formulas 1
Importing named range from another workbook 5
Importing data from excel spreadsheet 2
Data from Web Excel 2007 0
Where is the Data Import Excel button in Excel 2007 6

Top