cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Help us improve the PTC Community by taking this short Community Survey! X

Database connection (Access and Excel)

Mr_Henry_M
14-Alexandrite

Database connection (Access and Excel)

Hi everyone!

 

How to fill in the configuration for the Access database, does anyone know? I tried (see screenshot), but obviously wrong. There is no example for this database in the Relational Databases Connectors Extension.

 

And is it possible to connect to Excel (as a database) in the same way? Or is it possible only through reading csv-files?

1 ACCEPTED SOLUTION

Accepted Solutions
slangley
23-Emerald II
(To:Mr_Henry_M)

Hi @Mr_Henry_M.

 

You will need to create your own extension using a third party jdbc driver for Microsoft Access.  Instructions are available on the Help Center for creating your own connector.

 

There are similar third party drivers available for Excel--nothing from Microsoft directly that we are aware of.

 

Unfortunately, we don't have any examples around this type of configuration since we don't test these scenarios, but perhaps someone else in the community can provide this level of detail.

 

Regards.

 

--Sharon

 

 

 

 

 

View solution in original post

1 REPLY 1
slangley
23-Emerald II
(To:Mr_Henry_M)

Hi @Mr_Henry_M.

 

You will need to create your own extension using a third party jdbc driver for Microsoft Access.  Instructions are available on the Help Center for creating your own connector.

 

There are similar third party drivers available for Excel--nothing from Microsoft directly that we are aware of.

 

Unfortunately, we don't have any examples around this type of configuration since we don't test these scenarios, but perhaps someone else in the community can provide this level of detail.

 

Regards.

 

--Sharon

 

 

 

 

 

Top Tags