Import single Cells from excel (1 Viewer)

[georg7]

Good morning guys,
I want to Import single cells from my Excel doc to my Access db.
Every week I get a excel doc with numbers that I've to add in the Access database.
That I can Import every week the datasets.

I've to Import cell(8,1) from worksheet Table_iut at the end of my Access table "Top".

Is it possible to create a macro or something like that?

best regards

 

[Gasman]

One cell?.

I'd just copy and paste?

 

[georg7]

Just to try it.
There are plenty more cells to import.

 

[Gasman]

Same location each time?

Could you just not link to the worksheet and process that.?

Accessing the cells, post 5 & 6

https://access-programmers.co.uk/forums/showthread.php?t=105418

HTH

 

[georg7]

That would work, but I don't know how to import a single Dataset. When I import it's Always the complete table.

 

[Gasman]

https://www.google.com/search?q=exc...e&ie=UTF-8#kpvalbx=_XiogXv-RNI6ChbIPwuup8AQ29

I think you need to supply more detail, a sample excel workbook and what explicitly needs importing?

 

[Grumm]

Why can't you just link Access to the Excel sheet ?
https://support.office.com/en-us/ar...workbook-a1952878-7c58-47b1-893d-e084913cc958

You can have 1 table that is in sync with the excel or if you don't want a link, create the table once then append the data manually when needed.