Link between MS Excel to P3 3.1 via ODBC.....
Featured Partner
Top Posters
Zainab El-Beialy
3 posts
Kamlesh Parmessur
4 posts
MR JUDE C ANYAEGBU
0 posts
GeoVe
0 posts
Ashkan Mohammadi
0 posts
Jeroen De Bauw
0 posts
Senior Planning Engineer
0 posts
Kristian Mcwilliams
1 posts
dagogo dan - jumbo
2 posts
Alex Lyaschenko
27 posts
Our Partners
Suraj,
You cannot do a live link in Excel via ODBC link. You can extract the live data and upload it back using Visual Basic to update P3. Same in SQL you have need a file to upload and update P3 using SQL statement or query. The best way is to use a database which is possible to have a direct live link using ODBC. Using this method you are directly inputting data to P3 but you need to know the structure of P3 first otherwise it will just produce an error if you’re updating the wrong field.
Regards,
Rodel
Do you know what the best programme to manage P3 database is? Of course, it is P3. And Excel is excellent spreadsheet programme. There is nothing wrong with any of them. And to make life easier, there are some ways information in each programme can be read by one another. But this should not mean that whole database can be managed “with ease” using other programme. If that was the case, why should one need P3, why not make the programme in Excel. Then we find that Excel is not designed for that purpose. Anyway the point I want to make is use the software what it is meant for. Use P3’s functions like schedule, level, global change etc to change P3 data. Then you can export or even dump the whole information from any layout to Excel. This can then be used to make charts and presentations (which are the strong capabilities of Excel). Another use of Excel could be changing a lot of information faster (by export and import) but even this can be performed with Global change in P3 without much of difficulty.
there is no easy way to make a live link between excel and P3.
the data base used by P3, is betrieve which is by the way a real bullsh..., so you have two choice
1- take a look at Ra, it is lacated in your installation cd and learn all those weird api and of course you must be a visual basic guru.
2- buy some extra software.
good luck
Depends on what you want to change. There may be better ways.