ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Front-End for an Excel Data Base (https://www.excelbanter.com/excel-discussion-misc-queries/59375-front-end-excel-data-base.html)

Venkat

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.


Bob Phillips

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.




Venkat

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



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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com