ExcelBanter - External Data Range Import to a Cell not Table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - External Data Range Import to a Cell not Table (https://www.excelbanter.com/excel-discussion-misc-queries/169100-external-data-range-import-cell-not-table.html)

gcutter

External Data Range Import to a Cell not Table

In Excel 2007 I am having problems importing data from Access into a cell.
Everytime I import it wants to put it into a formated table and not a single
cell. I am used to Excel XP giving the option to include Field names and
being able to import the Number into a single cell. Is there a way to do it
in Excel 2007?

All times are GMT +1. The time now is 06:50 AM.