We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

macro, calc get data from db, do i have to use odb file [closed]

asked 2013-03-11 09:09:58 +0200

fs gravatar image

i want to use macro to achieve next purpose :

in a calc file, there is a button, i want to click this button to get data from db, and put the data in the database range( cells range in calc file), there are 2 solutions as far as i know :

  1. create a .odb file manually, register it as data source manually, then use this data source in macro to connect db and import data to database range

  2. create and register .odb file by macro, then use it to connect db and import data to database range.

both these 2 solutions need to use .odb file.

so can i achieve my purpose without .odb file?

Thanks in advance!

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by Alex Kemp
close date 2015-11-03 01:59:02.989870

2 Answers

Sort by » oldest newest most voted

answered 2013-07-02 02:49:48 +0200

m.a.riosv gravatar image
edit flag offensive delete link more

answered 2013-07-01 21:43:01 +0200

xerostomus gravatar image

I have exactly the same problem - I have db in base and I want to send sql request to DB, process it in calk and send data back to db.

edit flag offensive delete link more

Question Tools


Asked: 2013-03-11 09:09:58 +0200

Seen: 1,037 times

Last updated: Jul 02 '13