Possible to select specific excel cells to import?

G

Guest

I wish to import specific cells from diffferent excel documents in a specific
sheet. The location of these cells are constant.

Is it possible to make use of TransferSpreadsheet and in that case how
should i configure it ?
 
J

John Nurick

Hi Angela,

Can you give us a clearer idea of what you need to do? Is the idea to
collect data from various cells in a workbook and assemble them into a
single record in an Access table, then repeat the process with another
workbook? Do you have any control over the workbooks (e.g. if they're all
made from a template, can you modify the template?)?
 

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

Import specific sheet from Excel workbook 6
Import from Excel Question 1
Excel How do I delete images in a specific range 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing via TransferSpreadsheet, receiving "type conversion fail 1
Dialog Box to Select Import File 4
why "Type Conversion Failure" import EXCEL into ACESS TEXT field 1
Possible to import a specific sheets data from excel into access? 1

Top