Can Excel work as Access :: MrExcel Message Board


 FAQFAQ
   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   FavoritesFavorites   StatisticsStatistics 
 RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
Online StoreOnline Store

MrExcel Message Board Forum Index -> Excel Questions

Can Excel work as Access
Post new topic   Reply to topic
Last Thread | Next Thread  >   Printable version
  Author    Thread

davis1189
Board Regular


Joined: 19 Sep 2003
Posts: 17

Flag: Blank

Status: Offline

 Reply with quote  

Can Excel work as Access

I have created a form in Excel. I would like to know if it is possible for the information from the spreadsheet to be utilized on the form as though this Excel form was an Access form? In Access, the information I show in datasheet view is able to be used as a record and can be accessed on the form.

In my search over the last days, I have found how I can use the form as an easier way to key information into the spreadsheet format, however, I cannot figure out how to take that same spreadsheet information and put it in a form.

What I need to happen is for project managers to be able to go in to the form I have created and use the drop down box to select their projects and the rest of the information show up as it shows on the spreadsheet.

Is this possible? I am looking at each row in the spreadsheet being a record (like a datasheet in Access).

Help! I know we should be using Access, but this option has been shot down. So, if I am not explaining this in a manner that makes sense and able to generate help, please let me know and I will take another stab at it.

Thank you!

Post Fri Sep 19, 2003 6:52 pm 
 View user's profile Send private message Send e-mail

Juan Pablo González
MrExcel MVP


Joined: 09 Feb 2002
Posts: 8580
Location: Marion, IL
Flag: Colombia

Status: Offline

 Reply with quote  

Re: Can Excel work as Access

Take a look at the Data | Form menu, or J-Walk's version, which is more powerful AND flexible, available from www.j-walk.com/ss
_________________
Regards,

Juan Pablo González
MrExcel.com Consulting

Read the Articles List and check out our Recommended links and Add-Ins

Post Fri Sep 19, 2003 7:35 pm 
 View user's profile Send private message Visit poster's website

Iridium
Board Master
Board Master


Joined: 16 Jul 2002
Posts: 2581
Location: Walsall, England
Flag: England

Status: Offline

 Reply with quote  

Re: Can Excel work as Access

May be off-topic and I've never really used Access but RDBMS is possible in xl

http://www.tushar-mehta.com/excel/newsgroups/rdbms_in_excel/index.html

HhTH
_________________

Post Fri Sep 19, 2003 7:44 pm 
 View user's profile Send private message

davis1189
Board Regular


Joined: 19 Sep 2003
Posts: 17

Flag: Blank

Status: Offline

 Reply with quote  

Re: Can Excel work as Access

Awesome. I am reviewing both of these. Thank you both very much. I will give an update on my progress.

Thanks again,
ND

Post Fri Sep 19, 2003 8:19 pm 
 View user's profile Send private message Send e-mail

davis1189
Board Regular


Joined: 19 Sep 2003
Posts: 17

Flag: Blank

Status: Offline

 Reply with quote  

Re: Can Excel work as Access

I tried both but it doesn't seem that I am getting the results I am looking for. Is there a way for me to copy a table into this forum to let you see what I am talking about?
[/img]

Post Mon Sep 22, 2003 3:38 pm 
 View user's profile Send private message Send e-mail

pennysaver
Board Master


Joined: 15 May 2003
Posts: 2189
Location: San Diego, California
Flag: Usa

Status: Offline

 Reply with quote  

Re: Can Excel work as Access

To post a sample of your spreadsheet, try using Colo's HTML Maker, found at the bottom of the page.

Post Mon Sep 22, 2003 4:18 pm 
 View user's profile Send private message Visit poster's website MSN Messenger
  Display posts from previous:      

MrExcel Message Board Forum Index -> Excel Questions


Forum Jump:
Jump to:  

Post new topic   Reply to topic
Page 1 of 1



Add To Favorites

 


Forum Rules:
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB: 2.0.4 © 2001 phpBB Group

Need help posting your first question? Read how to post

Need extra help ? Couldn't get the answer you needed ? Get a free quote from our Consulting Team

Download Colo's HTML Maker utility for displaying your Excel Worksheet on the board.

Download VB HTML Maker to post your code on the board


Check out our new index to 485 Excel Articles.


Return to MrExcel Consulting

All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the Terms of Use
Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.