How do you find what version of Excel you are using?

I have a Microsoft Office 365 Business subscription.

Click File on the main menu of a Excel document to bring up a list of other items that you may want to find out as shown.


ExcelVersion_0

Click Account to open the account details on the right as shown.

ExcelVersion_1

Click About Excel on the icon to display the following:


ExcelVersion_2

The version used here is x32 bit.

How are User DSN, System DSN and File DSN are different?

ODBC User data source stores information needed to connect to the data source that is targeted for connection.

DSN is needed to connect to a data source and it stands for Data Source Name.
User DSN:
Only visible to the user who created it and can only be used on the computer on which it is created.

System DSN:
It is available for all users of the computer on which it is created including NT Services.

File DSN:
It can be shared by users who have the same drivers installed on their computer.

Obviously File DSN is more portable than User DSN

How do you create a DSN?

All Windows installations have what is called a ODBC Data Source Administrator, a program to create, maintain or modify data source access that use SQL as a data source standard language.

Search ODBC Data Source on our desktop.