Real time connection between Calc and Base

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Real time connection between Calc and Base

Postby trivender » Mon Feb 18, 2013 10:09 pm

I have 50 agents in my team. Each agent have there own spreadsheet(file1,file2..).Daily they log the number of orders they process in seperate sheet of there file and the whole month production reflect in master sheet. Now when i have to make a mothly production report then I have open evey indiviudal file. I want to create a database using Open Office base so that the date from my master sheets of every individual should be dynamically updated in base.I created table with the headers matching to the headers in master sheet of my calc.I am also able to import the date but it dont update dynamically.I have attached the file for reference.Please help
Attachments
file1.ods
file
(16.21 KiB) Downloaded 167 times
OpenOffice.org 3.3.0
OOO330m20(Build:9567)
OS:Windows 7 Ultimate
trivender
 
Posts: 26
Joined: Sun Jun 17, 2012 4:22 am
Location: New Delhi,India

Re: Real time connection between Calc and Base

Postby Villeroy » Mon Feb 18, 2013 10:40 pm

You can automatically refresh the database import range every 10 seconds or so.
viewtopic.php?f=75&t=18511&p=196704#p196704
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28149
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 1 guest