进行中

Automatic load excel files from a folder into an Access table

Everyday We have an Excel with all information about our ítems (sales, inventory, ...) and I need an application thqat automatically load this Excel file data into an Access database table. From the Excel file name it needs to take the date and load all records from the Excel file (just Sheet 1). Attached you have the Access(the table has already data from 1 Excel file as an example) and some examples of the Excel files to load. The application has to ask for the Access file and the folder where the Excel files to load are, and it should load all records from all Excel files into the Access ITB table. If the Access file has already records from the Excel file (based on the date of the Excel) it has to delete all records from this date first.

The older Excel files don´t have all of the columns as the new ones so we will load just what we have, they should have the same names of the columns always, please check it.

Thanks, Roberto

Access and examples of the source excel files. The table is already created and from the excel we just need sheet1. Please check old excel files to review if the columns are all the same and can be loaded (the newer ones have more columns). The date for access table has to be taken from each excel file name.

https://www.hightail.com/download/OGhkanZsUnJUME1YRHRVag

技能: 数据处理, Excel, 微软Access, SQL

查看更多: sales folder, i need an access database, example of inventory database, automatic data processing, ask excel, Roberto, excel inventory, access delete, excel access table, inventory files, load excel, check data excel files, excel sheet data inventory, excel file columns, check excel files, file name excel, excel data table, sales inventory application, inventory data excel sheet, access database inventory sales, database sales inventory, database access inventory, inventory data access, inventory examples access, please check date attached file

About the Employer:
( 5 reviews ) Mexico DF, Mexico

项目ID: #5216407

已悬赏给:

Premshanks

There are following columns in excel Prod Code Description Avg Sales last mnth sales 3mth Sales Fcst OTI QA QOH MTF Bulk /QAPS IT Review MOH B/O INT BO True BO PIP Expected MOH Make This Month Make 更多

$72 USD 在3天内
(213条评论)
6.1

32名威客为此工作的平均竞标价是$122

illuminesoft

We are amongst top 1% global outsourcing providers. We have successfully finished over 430 projects in last 13 years. ID : 5216407 Greetings, We are interested to work on this project, please find my comments in 更多

$277 USD 在15天内
(307条评论)
7.6
alexanderavw

Предложение еще не подано

$111 USD 在3天内
(65条评论)
7.4
bharanisrihari

Hi, I'm an Excel expert / VBA programmer. I can get your requirements done perfectly! Please refer the excellent reviews for my completed projects in Freelancer.com. One of the reviews for your reference: "Where 更多

$111 USD 在5天内
(64条评论)
6.4
cheapexcell

Hello, Roberto, attachments are missing =====================================================================================================

$99 USD 在3天内
(72条评论)
6.1
mrbrave

I had created a tool similar to this one in past for one of clients... Please check the video of how it works..I can develop similar for you. [url removed, login to view]

$74 USD 在2天内
(120条评论)
5.8
finecodervw

Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS Access etc.. I have worked on MS Access 97,2000, 2003, 2007,2010 projects both big and small using MS Ac 更多

$100 USD 在6天内
(65条评论)
5.8
pkcyber

I can develop the application for you, it will be a simple windows application in dot net, where you can select the access db and excel file (or path of excel file) and system will do the stuff as you have mentioned in 更多

$100 USD 在2天内
(26条评论)
5.5
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [url removed, login to view] Looking for further discussions in this matter. with than 更多

$98 USD 在4天内
(34条评论)
5.5
expertcoder1vw

I'm an expert Access / VBA / Excel / database application developer and can deliver a Windows application that will allow to select the Access file, the folder containing Excel files and will then do the data processin 更多

$149 USD 在3天内
(28条评论)
5.3
winnet21

Hi, I have experience with this project please refer programs that I done here: [url removed, login to view] I send a demo Import data form excel to access : [url removed, login to view] 更多

$155 USD 在7天内
(18条评论)
5.1
maverick44000

Hi there. With over 8 years of experience in Excel and Database (specially Access), I can deliver the project in 4 days. I have read the project description and downloading the files now. I am pretty sure that I can ma 更多

$160 USD 在3天内
(19条评论)
4.9
sswijaya

A proposal has not yet been provided

$90 USD 在3天内
(35条评论)
4.8
elboukharimu

Hi, I'm very interested helping you creating your Access database, I have more then 7 years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, th 更多

$231 USD 在3天内
(18条评论)
4.7
wesolvevw

Hello, Please share the database and sample [url removed, login to view] platform do you expect the application to be. Will a .NET app work for you? Thanks

$84 USD 在3天内
(33条评论)
4.5
infoshree80

Hi, Having more than 12 years of experience in development.I have done so many access application. I am ready to start immediately. Please send excel and access file . Thanks Chetnaa Desai

$82 USD 在5天内
(15条评论)
4.6
abupabuya

hi sir.i have a list Email was extracted from their own [url removed, login to view] this email functional intended for their business coz its extracted from their own web site u can use this for email marketing ---------- 更多

$100 USD 在3天内
(9条评论)
4.0
sayli2

Very is simple task for [url removed, login to view] did that kind of work. I can do interface from which you load excel file and import data in ms access. thanks.

$49 USD 在5天内
(22条评论)
3.3
swarm22

I have +4 year experiences in ms access database with export import data through excel . To provide quality , result oriented and supportive work. Thanks & Regards Hardik Dumaswala

$222 USD 在10天内
(4条评论)
2.8
driverahz

Hello, I can develop your application. I'm a Freelance With 10 Years of Experience In Developing Applications On Ms Access For Small, Medium And Large Companies For Public And Private Sector.

$100 USD 在2天内
(1条评论)
2.4
ahf76025

Hola, puedo ayudarte con la tarea que solicitas. Tengo amplia experiencia en desarrollo sobre MS Access. Actualmente he desarrollado una herramienta de facturación donde se incluye un método de importación de Excel a l 更多

$133 USD 在3天内
(1条评论)
0.4