Đang Thực Hiện

MS Excel to MS Access Data Integration

Our product inventory is stored in a Microsoft Access database that is linked through ODBC to a SQL database. The table in Access contain many different fields that contain the description and other details describing the products. This Access database also links to the SQL database which contain other information about the products such as QTY AVAILABLE, QTY ON HAND, CURRENT COST. So for example, if item#5555 in Access may have field for Name, Brand, Color, Size, Weight, Gender, Selling Price, UPC Number, and many other fields describing the product, this database in Access also links to the SQL table (from our accounting software) that has item#5555 COST, QTY, and other realtime information. In Access, we can easily create queries to produce product price lists where qtys are greater than 0, offers by brand, and other reports.

There are two features we are trying to add. The first is as follows. Many of our customers often send us long "wish lists" in excel format with sometimes thousands of items where we need to quote them our best price, qty, and possibly one or two extra fields containing some relevant information. At the moment, we have to manually review these "wish lists" and look up in our system which items we have in stock, what qty we have, and what our current costs and selling prices are. Since the wishlists our customers send to us contain in them the customers permanent item code also, we are seeking to eliminate our manual review by automating the whole process by matching our customers item numbers with our corresponding item numbers. We would like a system where we can simply dump their wishlist excel file into Access or Excel or some program and it would automatically match up the items from our access table and pull the relevant information and write them directly on their wishlist "Qty Avail", "Price" etc etc... Also there should be a report each time we do this for NEW SKUs that have not yet been mapped so that we may map them for the first time.

The second thing we are trying to achieve is generating a query that adds our vendors inventory to our own. Our vendors will send us an excel file that contains a column with their SKU, Item Name, Qty, and Price. We would like to dump this excel file into Access or Excel that will automatically find which SKUs our vendor has that we are currently out of stock, add those SKUS into our Access Query or Excel file, and also input our selling price based on a formula adding our margin on top of our cost price.

All this can be more easily explained with a session on Go to Meeting where we can present visual references to explain the objectives we are trying to reach above.

Kĩ năng: Xử lí dữ liệu, Excel, Microsoft Access, SQL, Visual Basic cho Ứng dụng

Xem nhiều hơn: integration access excel, microsoft excel access integration, cost access excel integration, data integration excel, what is data input, vendor database ms access, top query, the best accounting software, sql inventory system, sql create table price, need of cost accounting, microsoft excel software, go to top code, find new brand name, find name brand, field in accounting, features of data processing, example of inventory database, data processing costs, best accounting system, access vendor database, integration excel access, what is ms sql, what is ms access, what is accounting cost

Về Bên Thuê:
( 0 nhận xét ) United States

ID dự án: #1733469

Được trao cho:


MS Access expert here.

$300 USD trong 2 ngày
(39 Đánh Giá)

13 freelancer đang chào giá trung bình $328 cho công việc này


I have 15 years exp in access and excel. I can do the project and make the data automated for you. Donna

$500 USD trong 5 ngày
(36 Nhận xét)

Due to the fact that you have the application up and running we don't see any problem to implement the 2 features you described. Effectively, quickly, elegantly and user friendly.

$360 USD trong 14 ngày
(26 Nhận xét)

Your requirement can be met with an application developed in MS Access. I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks [login to view URL]

$450 USD trong 15 ngày
(3 Nhận xét)

Done before in Perl.

$250 USD trong 5 ngày
(1 Nhận xét)

Hi, I am willing to work with you on this project,

$250 USD trong 4 ngày
(3 Nhận xét)

Developed and currently support such a system.

$250 USD trong 3 ngày
(0 Nhận xét)

i like a [login to view URL] give me a one chance to work this Project.

$300 USD trong 2 ngày
(0 Nhận xét)

I have experience in Supply Chain Management systems. I have worked on similar system. I'd like to work with you in this project.

$300 USD trong 3 ngày
(0 Nhận xét)

I am ready for this work....

$350 USD trong 2 ngày
(0 Nhận xét)

Dear Sir, i have understood your requirement .i am eager to work in this project and i am assuring you ,i can easily develop this kind of report to upload data into the database from ms-excel.

$250 USD trong 7 ngày
(0 Nhận xét)

My name is George Panko, dba The Immaculate Collection. I am relatively new to Freelancer.com, but am well-established on Guru.com. Since 2001, I have specialized in designing, developing, and maintaining MS Access da Thêm

$250 USD trong 5 ngày
(0 Nhận xét)

I've developed several Excel/Access applications which have similar requirements to your project (ie Excel to Access integration) Job can probably be completed in a day if source data is structured well.

$450 USD trong 3 ngày
(0 Nhận xét)