Building Asset Hierarchies with PI AF Online Course - Create Attributes with Table Lookup Data Reference & Build PI AF Tables
The part with importing from Excel does look different from my end.
Can you clarify why I am not seeing the "Excel Files"-drop down from 'Use data source name' in the screen below?
Hi Rebin Said,
Are you on PI System Clients VLE environment on server PISRV1? If so, Microsoft Excel should be installed on this environment, so Excel Files should be a Data Source Name option for the OLE DB provider. Make sure to select the correct OLE DB provider of "Microsoft OLE DB Provider for ODBC Drivers" on the Provider tab, and then on the Connection tab when you click the down arrow at the right of the box below "Use data source name" you should have options of "Excel Files" and "MS Access Database" in the drop-down menu.
If nothing appears in the drop-down menu, try clicking the Refresh button beside the drop-down menu box, and then click the down arrow again after that.
If you are not using the VLE environment, the machine you are running PI System Explorer (PSE) on should have Microsoft Excel installed to make sure you have the correct OLE DB drivers installed to import Excel Files into PSE tables.
Let me know if that works for you or if you are still having issues.
James Owens this works on the VLE.
However when I try the same on my own machine / server / database I receive an error and MS Excel has been installed for sure.What could be the reason?
On your own client machine, do you see "Excel Files" as a data source name option for the "Microsoft OLE DB Provider for ODBC Drivers"? What is the error you receive?
No I am not seeing "Excel Files" as a data source name option for the "Microsoft OLE DB Provider for ODBC Drivers". It is simply empty..
So I am not seeing an error (yet), as I am unable to select a data source.
This is an ODBC connection that requires an ODBC driver for Excel to be installed on your machine. You can check to see if this is installed by opening the odbcad32.exe program ("C:\WINDOWS\SysWOW64\odbcad32.exe" for 32-bit Microsoft Excel or "C:\WINDOWS\System32\odbcad32.exe" for 64-bit Microsoft Excel). Go to the Drivers tab, and you should see an entry for Microsoft Excel Driver. If you do not see this, you can install the Microsoft Access Database Engine Redistributable to get this ODBC driver. This is a Microsoft installation, and you can find it on their downloads site.
Once the driver is on your client, you should see Excel Files as a data source option for the "Microsoft OLE DB Provider for ODBC Drivers" provider in PSE.
I have checked the .exe program you have mentioned. It does show the Excel driver.
Met vriendelijke groet / Kind regards
Associate Data Engineer - Dept. PI Center of Excellence - Amsterdam GW01
Shell Technology Center Amsterdam
Visiting Address: Grasweg 31, 1031 HW Amsterdam
Post Address: Postbus 38000, 1030 BN Amsterdam
• +31 -(0)020 630 7337 / Skype for Business: rebin.said
E-mail : email@example.com<mailto:firstname.lastname@example.org>
In that same odbcad32.exe program (make sure you run the one that is the same bitness as your version of Excel), check the User DSN tab and see if you have Excel Files listed as one of your User Data Sources. If not, try adding it following similar instructions to this Microsoft Office support article. The configuration should look similar to the following:
Then make sure to run PI System Explorer that is the same bitness as Excel as well (32 or 64-bit).
I indeed also think that it is related to the bit versions..
Retrieving data ...