?
Solved

Convert an excel Spreadsheet to Access forms

Posted on 2007-11-22
5
Medium Priority
?
735 Views
Last Modified: 2016-08-29
I  have  an excel spreadsheet that is used to control the daily workflow of up to 4 drivers from 2 different companies
that work for us,  at the top of the form you have the company and the driver name

The information that is in this  spreadsheet that is created manually is already stored in my shipping
system (MSACESS 2K FE/SQL SERVER BE) as follows:
in the tblCarrier I have the carriers
in the table tblCarrierDrivers I have the drivers

My question is How can I create a form in Access that will reproduce the format of this spreadsheet
since the dispatchers have been working with this  thing for a while it will be easier for me to make the change less painful by using something very similar in order for them to do their work.
I had posted  this previously and got no response.

The excel spreadsheet in question is located in EE stuff under the number of the old question I hope the links work still
if they do not please let me know to re-post the file.

View all files for Question ID: 22946081
https://filedb.experts-exchange.com/incoming/ee-stuff/5434-border-crossing.zip 

Direct link to your file
https://filedb.experts-exchange.com/incoming/ee-stuff/5434-border-crossing.zip 
0
Comment
Question by:TOPIO
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 12

Accepted Solution

by:
dlan75 earned 2000 total points
ID: 20336384
Hi,
I would import the spreadsheet into Access in a table then would create a form linked to the table and arranging the fields in order to match the spreadsheet design.
0
 
LVL 10

Author Comment

by:TOPIO
ID: 20336760
The problem is that I already have some of the tables that integrate the excel spreadsheet were you able to download it?
0
 
LVL 9

Expert Comment

by:tonydemarco
ID: 20340120
Why do you have 2 trip 1's.
0
 
LVL 10

Author Comment

by:TOPIO
ID: 20360083
I have two trip 1 by error it was intended to be trip 1 then trip 2 etc
0
 
LVL 9

Expert Comment

by:tonydemarco
ID: 20360413
I think that you got your from dlan75.
I would recreate the look of the spreadsheet in the Access form.
It just takes some layout work, unless I'm missing something, it looks pretty straight forward.
There is no way to effectively import a working spreadsheet/form into an Access form.
It is possible to import the form as a picture and then place fields over it but this is clumsey and sometimes more work than creating from scratch.

Hope this helps
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question