Skip to content
View in the app

A better way to browse. Learn more.

Thailand News and Discussion Forum | ASEANNOW

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Search Excel Database Within Website

Featured Replies

I have a large dictionary-like database, (16,000 entries in abc order) that I'd like to have be searchable online. It's in Excel format.

I'm able to paste one type of search facility online - which looks for web pages within a specified domain, but it pulls up a list of web pages - which is not what I'm aiming for.

Instead, I'd like to designate a column of the Excel file as searchable (let's say column A) and have the software bring up all corresponding matches and their definitions - within the dictionary format.

Software recommendations are appreciated, particularly if they're freeware.

I'm also open to hiring someone to do the service, but am low income, so could only compensate by trade - magazines, books, whatever - or services that I offer like editing, publishing, etc.

By far the easiest way would be to export your data into a mySql database using CSV or XML and then using PHP to access the database. Mysql is supported by many hosting companies and is often included as standard. To do the import to a mysql database you can use phpmyamin which is a free script. This sounds pretty complicated but in fact programs like Dreamweaver will generate all the necessary code.

Other options would be something like Spry XML datasets from Adobe which again would generate all the code provided the source file was in XML format.

There are also many other ways this could be done using various server side scripts or even javascript.

Hope this helps

  • Author

Thanks to Phuket Mike. I transferred what you wrote to a file - for reference.

I must admit it looks daunting to a digitally challenged person like me. I can understand analog things like manual can openers and nail clippers.

If Mike or someone similarly adept could assist in the process (of rendering my database searchable online) then I'd be glad to trade something for the favor. Ordinarily, I'd also be glad to pay, though I'm not ordinary and money's tight for me at this time. I got mags I could trade: Discover, Nat'l Geographic, and others.

The easiest way to do this is to use the excel odbc connector supplied with excel. Drop it on your wesite and you can connect to excel flat database.

Create an account or sign in to comment

Recently Browsing 0

  • No registered users viewing this page.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.