Excel to Access

  AndySD 11:56 11 Apr 03

I have been askedhow or even if it is possable to export specific cells in an excel document into an access database. The cells are in a large excel worksheet used as a form.

  Tj_El 12:31 11 Apr 03

I'm no expert on Access but I wouldn't think it possible to import specific cells. From the 'little' I know, you can import selected columns only but not cells.

However I may be proved wrong in this.

Why not simply import the whole spreadsheet and use a query to select the particular cells required?


  Morphy 13:11 11 Apr 03

If you want to import a range of cells, eg A1 to A6, then you could name the range, then import the range by itself.

Alternatively you could link this with Tj_El's response if the range was on a single row, so that you could have eg A1, A3, A4, A6 etc.

However, if the range is more than one row, then the second row would fall into the next record in your Access table. You could get round that but it would probably get a bit complicated...

This thread is now locked and can not be replied to.

Microsoft Surface Studio PC release date, pricing, design, features and spec: Microsoft showcases…

1995-2015: How technology has changed the world in 20 years

This amazing app turns your iPad Pro into a Cintiq

Apple Q4 2016 financial results | Apple earnings report: iPhone, iPad and Mac sales down, profits d6…