VB code to insert/get data

  • Thread starter Thread starter Piotr
  • Start date Start date
P

Piotr

Hi where can I find information and examples about inserting data to
databse and getting from DB to excell ?
As far I know I need to use VBA code ?

regards
Peter
 
Hi Peter

you can also query a database via data / get external data / new database
query option ... and use MS Query to set criteria etc - unfortunately i'm
not aware of any websites that have a write up on this.

Cheers
JulieD
 
I would rather use coding to let user change for example month period
etc. as I want them to connect to DB from outside of the local network
it would be better to querry just a minimal portion of data instead of
filtering through a querry.

U¿ytkownik JulieD napisa³:
 
Back
Top