Project Detail

Excel access to database

Excel access to database is project number 335596
posted at GetAFreelancer.com. Click here to post your own project.

Status: Closed
(Selected Service Provider)

Selected Providers: ServiceQuality

Budget: $30-250

Created: 10/28/2008 at 22:19 EDT

Bid Count: 20

Average Bid: $ 108

10/29/2008 at 22:19 EDT

Project Creator: john58
Employer Rating: 10.00/10 (1 reviews)

Description

This is probably a simple question to answer, but I don't have the answer. I am not a programmer, but can do the basics of creating an MS Access table, and do some creation work in Excel and Word.
I have a document in Word which is an invoice. It is linked by mailmerge to an Access table. The invoice does calculations for a rental bill. I need to send out rental bills to 6 rentors. First I enter data into MS Access. This data changes somewhat each month. Then I open the Word document and move from record to record confirming that the bills are filled out and calculating correctly. Then print copies and send the bills out.

Here are my questions which I have not been able to find answers for on the web. The answers may be simple but I have spent too much time already trying to find them.

1. Can I use an Excel document to make calculations and move from record to record in Excel and have the data supplied from my table in MS Access? I would rather use Excel than Word, but Excel doesn't seem to have a mailmerge type of functionality.

2. Could I instead use Microsoft Office Accounting Express to do this billing? I want to have one invoice that does all the calculations and moves from record to record just like in Word.

I just need someone to tell me what the options are, if additional software (such as add-ins) is needed, or if I should just stick with the current working method of using Word, mailmerged to Access. For this information, I am willing to pay someone. I send out 6 bills each month to 6 different rentors. Each bill looks similar, but has different figures. I have also created 6 Excel workbooks, but this means I have to enter data into each one individually, and it would be easier to enter the data into a table in some database, whether Access or some backend database in an already existing program like MS Office Accounting, which I have.

Thank you.

Report Violation

Job Type

Messages Posted: 3

If you are the project creator or one of the bidders Log In for more options

PMB

150

2 days

10-29-2008 01:37 EDT

9.50/10 9.50/10 9.50/10 9.50/10 9.50/10 9.50/10 9.50/10 9.50/10 9.50/10 9.50/10
(4 reviews)

Hello - It can be done in excel using Access as the data base. Please refer to PMB.

mahfuzmurshed

3 days

10-29-2008 00:17 EDT

10.00/10
(1 reviews)

Please see PM

Abikris

100

1 day

10-28-2008 23:57 EDT

10.00/10
(1 reviews)

See PM for details

cnut17

2 days

10-29-2008 06:47 EDT

10.00/10
(1 reviews)

yes, this can be done as a one button automation. simply, excell is not made to do database operation. even if you can import/link data from acces, it's easier to make all calculations in access and then lauch the mailmerge from word. if the bill layout changes a lot between customers, we can even build the word document dynamically from access. everything is possible, but the simplest is the best...

ServiceQuality

3 days

10-29-2008 13:20 EDT

10.00/10
(1 reviews)

We are sending some answers and recommendations in a Private Message.

Shoaibik

199

10 days

10-28-2008 23:01 EDT

(No Feedback Yet)

I can do it.

jsnolasco

150

5 days

10-28-2008 23:16 EDT

(No Feedback Yet)

You said you already have a database with information for the invoices right? It is very easy to transfer data from access to excel. If you choose me, just describe in detail what you need, and I guarantee you will be satisfied with the outcome. Hope we can work together.

mrkibria

1 day

10-29-2008 00:19 EDT

(No Feedback Yet)

Hi! See PM for details.

romytiu

150

3 days

10-29-2008 00:41 EDT

(No Feedback Yet)

You can use VB6 then output report to excel. But I'd rather suggest to use VB6's datareport for your mailmerge requirement. I can do this in 3 days. Just send me the format of your billing and the structure of your access database. I will send you the program and you only pay when satisfied.

sureshyd

5 days

10-29-2008 01:13 EDT

(No Feedback Yet)

i can give support as per your requirement

jweinke

1 day

10-29-2008 03:25 EDT

(No Feedback Yet)

It would be better if you create a report in Access that does the calculations. The report would be your invoice, doing away with Word altogether. I could this if you're not sure how.

ebedsat

150

3 days

10-29-2008 07:15 EDT

(No Feedback Yet)

I will write a program for your access database. You can input, check your data and print your invoice.

sureshnair282

2 days

10-29-2008 07:21 EDT

(No Feedback Yet)

hai just send me your data structure and report format you will be satisfied

cuitw

150

4 days

10-29-2008 07:34 EDT

(No Feedback Yet)

Hi, The answer of your first question is yes while some import might be require. I don't know nothing about Microsoft Office Accounting Express. The price I quoted here is for making a program that can import the data directly from your access database/excel and do the calculation and generating shipping labels when you need to. If you are willing to pay $550 I can provide a program of front-end solution with every part of your work covered. Please note that no deposite is required, you do not have to pay for my program until it is working and you are satisfied with it. Best regards, cuitw

sameerjeez

3 days

10-29-2008 08:11 EDT

(No Feedback Yet)

• Layout Designing Expert Adobe Photoshop, Adobe Illustrator & Macromedia Freehand, Publishing Expert Macromedia Freehand, Corel DRAW, Adobe Photoshop, Adobe Illustrator, Adobe Acrobat & Adobe Streamline, QuarkXpress, Web Design Intermediate Photoshop, Flash & Dreamweaver. Inpage, Miscrosoft Office 98/2003 (Word/Excel/Access Power Point) Windows 98/2000/XP/Vista/Mac , Animation Intermediate Macromedia Flash, Adobe Image Ready,

pvccpr1965

150

7 days

10-29-2008 09:45 EDT

(No Feedback Yet)

I am a software programmer and make all it automized. You have to enter only figures rest the part will complete autometically.

leenaam

100

2 days

10-29-2008 10:11 EDT

(No Feedback Yet)

I am intrested in this projet please contact me. I have my team of 3 people to work here in my company

ashiruddin

150

2 days

10-29-2008 12:16 EDT

(No Feedback Yet)

It is very simple and easy project for me, the solution is in the excel VBA, VBA can retrive the MS Access data into excel sheet of any custom format and you can see 1 by 1 record through excel templete, and can generate multiple sheet of all bills. you can depend on me.

gaurangt9

100

10 days

10-29-2008 14:18 EDT

(No Feedback Yet)

I can do it.

mnash0915

200

3 days

10-29-2008 14:55 EDT

(No Feedback Yet)

I am an accountant that now does access database development so I can develop what you need in Access/Excel as well as keep the accounting aspect in mind. Thank you!!

Bid on this Project

WHAT IS GETAFREELANCER.COM?

Get A Freelancer is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.