Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Venkat
 
Posts: n/a
Default Front-End for an Excel Data Base

Greetings,
I'm hoping to create a Data Base with Excel, but would like some to
use other program as the front-end. Which would the Ideal Front-end for
the same? (Appending & Querying must be preformed with ease.)
Thanks
Venkat.

  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Front-End for an Excel Data Base

That sound's totally back-to-front to me. I can understand using a database
somewhere else and Excel as a front-end analysis tool, but the other way.

You would probably have to use an ODBC connection into the Excel file,
unless the other product supported ADO and OLEDB, which is not good. Why
would you want to do it that way?

Having said that, I have queried Excel tables using Brio.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Venkat" wrote in message
oups.com...
Greetings,
I'm hoping to create a Data Base with Excel, but would like some to
use other program as the front-end. Which would the Ideal Front-end for
the same? (Appending & Querying must be preformed with ease.)
Thanks
Venkat.



  #3   Report Post  
Posted to microsoft.public.excel.misc
Venkat
 
Posts: n/a
Default Front-End for an Excel Data Base

Thanks Bob,
I know it's Inside Out, but it's a Simple Project for a Co-op to
manage their Address DB which is there in Excel. They R reluctant to
change their DB from Excel. Think I will go with Access.
- Venkat

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Excel 2003, Convert EXISTING Worksheet Data to XML? [email protected] Excel Discussion (Misc queries) 4 November 16th 05 04:45 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
How do I fix my excel data base? Millie Irene New Users to Excel 5 February 16th 05 07:33 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


All times are GMT +1. The time now is 07:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"