|
|
using excel form to input data into access
Is it posible to use an excel spreadsheet to enter data into access?
please reply to group
|
|
0
|
|
|
|
Reply
|
 billb
|
4/15/2007 12:55:32 AM |
|
You can link access to Excel. But why? before going any further, explain
the reason why you would want to do this. Let us evaluate what your needs
are.
Access Forms are much better for data entry, for a number of reason, than
Excel. What would you use acces for then if your data is being entered and
stored in Excel? Explain some more so we can guide you better.
--
Hope this helps,
Daniel P
"billb" wrote:
> Is it posible to use an excel spreadsheet to enter data into access?
>
> please reply to group
>
>
>
|
|
|
0
|
|
|
|
Reply
|
Utf
|
4/15/2007 2:44:02 AM
|
|
The actual reason for using excel to enter the fields in access is that over
100 of our users are familiar with excel, but do not know anything about
databases. They actually call excel a database about 1/2 of the time.
We work in a contract research facility that does lots of different projects
in several scientific disciplines of varying complexity. I started using
databases to store my research data in back in the 80's with db3. We did not
even have an IT department until about 2 years ago. I have been trying to
drag our company into today's world for the last 15 yrs, and am convinced
that the only way I'm going to get this done is if I create excel worksheets
that they fill out and the data goes into a database that I can then show
them what benefits and additional data evaluation techniques are available.
"Daniel" <Daniel@discussions.microsoft.com> wrote in message
news:1DDD62DE-8FAC-42DB-8287-F2CC4999E474@microsoft.com...
> You can link access to Excel. But why? before going any further, explain
> the reason why you would want to do this. Let us evaluate what your needs
> are.
>
> Access Forms are much better for data entry, for a number of reason, than
> Excel. What would you use acces for then if your data is being entered
> and
> stored in Excel? Explain some more so we can guide you better.
> --
> Hope this helps,
>
> Daniel P
>
>
> "billb" wrote:
>
>> Is it posible to use an excel spreadsheet to enter data into access?
>>
>> please reply to group
>>
>>
>>
|
|
|
0
|
|
|
|
Reply
|
billb
|
4/15/2007 10:08:52 PM
|
|
|
2 Replies
561 Views
(page loaded in 0.066 seconds)
12/5/2013 12:05:54 PM
Similiar Articles: Populate Excel form using Access - microsoft.public.access ...I came into Access with no prior db experience, and Excel with only ... opposed to forms to input data) in excel and thats what i do. i love access forms and i use ... Excell data input form that links to/inserts data to Access Databa ...Excell data input form that links to/inserts data to Access Databa ... Input distanct from a map into excel - microsoft.public ... do I view complete text content in an ... Access Data Input - Multiple Users - microsoft.public.access ...... with data input as multiple users attempt to access the data form ... public.excel ... Access Data Input ... m using Access 2000, can I have multiple users input data into a ... Input Excel 'Password to Open' through control in access form FollowMove the code from the Control ... Excel 2007 Functions in Access 2007 ... Using a form to input ... ... form | Excel data form tutorial... entry using the Excel data form ... Input Form Field Names in VBA - microsoft.public.access.forms ...... with that stored data. They are NOT interchangable! >The sequence goes something like >this: > >1) Using an Input Form ... as John suggested, in Excel, or ms-access ... How-To:Create input form of products sold vs year - microsoft ...... that data without having to repeat entering each vehicle name and using a form ... in Excel? - microsoft ... How-To:Create input form of ... access.forms How-To:Create input form ... Message box when data is entered in a form - microsoft.public ...I have a data form that the users use to input data. ... for duplicate data - microsoft.public.access.forms ... Excel - Verify Data Entered In Text Box In User Forms - I have a ... Using Access form to assign values of variables in an Excel VBA ...... Ms Excel.But,to get desired results, every time, I go into ... Data ... Using Variables in Excel VBA Macro ... Input Form Field Names in VBA - microsoft.public.access ... Word 2007 how to get data from forms to Excel - microsoft.public ...Excell data input form that links to/inserts data to Access Databa ... Linking excel ... Word form data into Excel ... How to Use a Data Form in Microsoft Excel 2007 ... Using Autotext in an input form? - microsoft.public.word.vba ...Has anyone set up a lending library in Access 2003? - microsoft ... Using Autotext in an input form ... PhraseExpress v8 Documentation Right-click into the Autotext input ... How to Use Excel to Input Data Into an Access Table | eHow.comHow to Use Excel to Input Data Into an Access Table. Microsoft Excel is a ... How to Create Input Forms in Excel 2003. Input forms give you an alternate way to enter data into ... Microsoft Access: using excel form to input data into access ...database.itags.org: Microsoft Access question: using excel form to input data into access, created at:Sun, 01 Jun 2008 11:41:00 GMT with 105 bytes, last updated ... using an excel 2007 template to input data into an access 2007 ...using an excel 2007 template to input data into an access 2007 table ... Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms ... How to Use Access Data in Excel | eHow.comHow to Use Access Data in Excel. Microsoft Access ... How to Use Access Data Forms to Edit Excel Data ... How to Use Excel to Input Data Into an Access Table Get data from Access form into Excel using ADO - Microsoft Access ...Get data from Access form into Excel using ADO. Microsoft Access ... the form which opens the Excel worksheet, which then basically serves as the input form for the Access ... 7/26/2012 9:05:52 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
39 followers. 