using mysql database external

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Using MySQL database as an external datasource | Excel forum

Using MySQL database as an external datasource | Excel forum

resolvedResolved · Low Priority · Version Standard

Nick has attended:
Excel Advanced course

Using MySQL database as an external datasource

Is is possible to use a MySQL database as an external datasource?

RE: Using MySQL database as an external datasource

Hi Nick

Thank you for your question

It is indeed possible to interrogate an SQL database.

Simply click on Data-Import External Data-Import Data.

You will then be presented with a list of data source types. Choose the relevant type, and then select the required file.

You will then have the ability to select required tables and fields

Hope this helps

Regards

Stephen


 

Excel tip:

Apply Autosum with keyboard shortcut

If you press Alt and = at the same time, it applies autosum.

View all Excel hints and tips


Server loaded in 0.07 secs.