By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,307 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

Need opinions on converting Excel db to Access/MySQL or ?

P: n/a
I'd love to hear some expert opinion on my situation. My department
relies on Excel as a database, which causes crashing due to resource
depleting and basically is just too slow. For example, a user must
open seven Excel workbooks so that each can lookup values in the other
to rollover into a separate "summary" workbook. Obvious problems
there.

What is your opinion on how this SHOULD be configured? They suggest
using Access initially, and that is what I know. Maybe later place the
Access tables onto a MySQL server and link via ODBC? I'm not too
familar w/MySQL, but based on what I've read it wouldn't seem to hard
to learn since I'm fairly good with Access, which I've been using for
about 2 yrs.

Anyone have any ideas on the best initial configuration, and then a
later configuration?

TIA,
John
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
One of those places that use Excel as a database system is it?

Re-engineer (don't just copy the Excel layout to Access, do it from scratch)
the whole thing in Access.

P
"John" <so*********@hotmail.com> wrote in message
news:90**************************@posting.google.c om...
I'd love to hear some expert opinion on my situation. My department
relies on Excel as a database, which causes crashing due to resource
depleting and basically is just too slow. For example, a user must
open seven Excel workbooks so that each can lookup values in the other
to rollover into a separate "summary" workbook. Obvious problems
there.

What is your opinion on how this SHOULD be configured? They suggest
using Access initially, and that is what I know. Maybe later place the
Access tables onto a MySQL server and link via ODBC? I'm not too
familar w/MySQL, but based on what I've read it wouldn't seem to hard
to learn since I'm fairly good with Access, which I've been using for
about 2 yrs.

Anyone have any ideas on the best initial configuration, and then a
later configuration?

TIA,
John

Nov 12 '05 #2

P: n/a
so*********@hotmail.com (John) wrote in news:90fab935.0310031317.258d9671
@posting.google.com:
I'd love to hear some expert opinion on my situation. My department
relies on Excel as a database, which causes crashing due to resource
depleting and basically is just too slow. For example, a user must
open seven Excel workbooks so that each can lookup values in the other
to rollover into a separate "summary" workbook. Obvious problems
there.

What is your opinion on how this SHOULD be configured? They suggest
using Access initially, and that is what I know. Maybe later place the
Access tables onto a MySQL server and link via ODBC? I'm not too
familar w/MySQL, but based on what I've read it wouldn't seem to hard
to learn since I'm fairly good with Access, which I've been using for
about 2 yrs.

Anyone have any ideas on the best initial configuration, and then a
later configuration?

TIA,
John


Hire a professional developer to assess your needs.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.