In Progress

Import Excel worksheet into Access database - Repost with further details - repost

I have an Access 2007 database with two tables in which I need to import an Excel 2007 worksheet.

There are a total of four different fields in the Excel file and I do not wish to manipulate the Excel file prior to being imported into the Access database. However, I'm unable to import the Excel file with my current level of expertise. I will send the Access and Excel files to the winning bidder and their job is to accurately import the Excel file into Access while maintaining the proper relational integrity of all entries. I have several Excel files that I eventually will need to import so, I need a solution that will do this seamlessly for me. Ideally, select a button labeled "Import", then select the Excel file I wish to import, and have Access import it into the proper tables all the while maintaining absolute relational integrity with the original data from Excel.

Winning bidder should also take time to explain precisely and clearly how they accomplished the importation so I can understand better about the process for any future needs I might have. The ideal bidder should have an extensive knowledge of Excel, Access and VBA.

Sample files are attached for review along with some further notes.

Skills: Excel, Microsoft Access, Visual Basic for Apps

See more: import excel worksheet access database repost details repost, microsoft access job, i need an access database, microsoft vba, microsoft excel VBA, how to microsoft excel, how to access vba in excel, excel 2013 vba, VBA and excel, vba access excel, microsoft access vba, in process access, import two, import excel, Excel and VBA, c# with access database, c# import excel, c with access database, c import excel, relational database microsoft access, microsoft excel excel level, excel 2007 vba, access notes database, excel access import data, excel manipulate data

About the Employer:
( 0 reviews ) Belgrade, Serbia

Project ID: #5209867

28 freelancers are bidding on average $34 for this job

SigmaVisual

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: [url removed, login to view] More

$103 USD in 2 days
(7 Reviews)
5.0
smb310570

Hello Dear aleksandarcantic, I do not see any link here to attach my sample database for you to import excel file into access. Please send me a private massage for this sample and I will send you by attaching this d More

$15 USD in 1 day
(15 Reviews)
3.4
SajjadHussain14

Have more than 10 years of database design and programming exp. So far developed many applications which import relational data consists of millions of records with 100% accuracy rate. Let me know if you are interested More

$55 USD in 3 days
(3 Reviews)
3.3
AndroidAll

Dear Sir, I'm interesting in your job. I have much experience in the MS Excel and VBA. I can do this job. Regards. PS. In order to show my ability, I can send my sample files to you.

$35 USD in 2 days
(3 Reviews)
2.8
rajafaizan

I am software [url removed, login to view] expertise lies in quality service and delivery on Time i guarantee you 100% satisfaction. kindly if you want high quality work then as soon as possible contact me. Hoping Positive Response. More

$29 USD in 3 days
(4 Reviews)
2.7
workerbee1974

I have been building Microsoft Accress Pograms for 16 years. I am an expert in 2003, 2007 and 2010. I can start from scratch or edit existing databases. I have many samples if needed. This can be done by linking th More

$35 USD in 3 days
(1 Review)
2.1
premsl

Hi, I have understood your requirement, but I don't see any attached sample files. It would be helpful if you could provide the sample files with detailed requirement specifications. Though, I have proposed you the be More

$10 USD in 2 days
(1 Review)
2.1
jimboyvw

I have projects with VBA (Excel and Access) since VWorker. Should you consider me to do the job, will assure you that you won't get disappointed. Have a nice day ahead!

$25 USD in 3 days
(1 Review)
1.1
pforino

I can easily handle this. I have extensive experience building macros to integrate Access & Excel. I have knowledge of VBA if we need to get more sophisticated. I placed the lowest possible bid because I need to bui More

$10 USD in 1 day
(1 Review)
0.7
chrisacct

I am a MS Office Specialist, working with both excel and access for work and non-profit events. I understand you want your excel files imported into the access database; as well as how it was done for future issues. I More

$15 USD in 2 days
(1 Review)
0.0
gogoulor

I've done several projects in ms access. and i really have expertise in excel please see [url removed, login to view] Please sent a test problem to test my skills. Best regards

$200 USD in 5 days
(0 Reviews)
0.0
willmansfield

Afternoon, I can create a VBA module which will read the data from the source file and then process any required manipulation before importing into an Access table. This will mean you don't need to edit either th More

$35 USD in 1 day
(0 Reviews)
0.0
matteip

Non hai ancora fornito una proposta

$25 USD in 1 day
(0 Reviews)
0.0
zapataluish

La propuesta todavía no ha sido proveída

$25 USD in 3 days
(0 Reviews)
0.0
isokac

A proposal has not yet been provided

$34 USD in 3 days
(0 Reviews)
0.0
MD03

Hi I got you requirement. Excel and Access have already inbuilt export function but we can't use that function for your project. This work we can do through VBA. I just have to make connection with your access file th More

$25 USD in 1 day
(0 Reviews)
0.0
Garyronaldo

Hello Sir/Madam We are from Ramachandra infotech Madurai TamilNadu [url removed, login to view] we have 80 + seat us in our office, We are successfully running a KPO/BPO and software development for more than 5 years. We have ded More

$25 USD in 3 days
(0 Reviews)
0.0
zelimircalic

A proposal has not yet been provided

$25 USD in 3 days
(0 Reviews)
0.0
martonlinecn

my current's job is export data from access DB, handly the data, and import the data back to DB. according the project description, I can finish you request very easily.

$15 USD in 3 days
(0 Reviews)
0.0
hasasap

The solution will be a button on the access screen. This button will prompt you to select a path for the excel file to be created. Or in case you want the file to be overwritten or appended check boxes can be selected. More

$24 USD in 2 days
(0 Reviews)
0.0