Code to import flat file from Excel to Access then split into related tables.

Completed Posted 1 year ago Paid on delivery
Completed Paid on delivery

I need to get excel data into access. Once in access columns from the excel data have to be split off and appended to the fields of separate access tables. these tables are related and so correct key values will be required to maintain the relationship.

Microsoft Access Excel Visual Basic SQL

Project ID: #36024779

About the project

46 proposals Remote project Active 1 year ago

Awarded to:

(632 Reviews)
8.7

46 freelancers are bidding on average £23 for this job

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am a More

£70 GBP in 2 days
(557 Reviews)
8.5
belalihabibullah

Dear sir, I can start to work immediately. INBOX ME I have just read your project description and I can help you with my experiences. I am able to work in your timezone. I did this kind of project before. EXPERTISE: E More

£20 GBP in 1 day
(142 Reviews)
6.5
WebInfoSolutions

can you sample excel and database tables structure in access?

£20 GBP in 1 day
(47 Reviews)
6.5
zu02

Hi, I am very good at coding MS Access application with Excel automation. I will solve your problem the way you need. Zurab

£15 GBP in 7 days
(83 Reviews)
6.5
professional800

Greetings Thanks for checking my proposal. I would import Excel data accordingly and maintain relationship accordingly. I am full- time freelancer having job experience of more than two decades. It included more than More

£19 GBP in 1 day
(119 Reviews)
6.0
fanninson45

I had done a similar Access projects before with 5* ratings: MY COMPLETED ACCESS PROJECTS: • https://www.freelancer.com/projects/microsoft-access/Doctor-clinique/details • https://www.freelancer.com/projects/microsoft More

£15 GBP in 3 days
(12 Reviews)
5.8
peteyjfife

Hello, I would love to help you on your project. I am a Microsoft Expert and Data Scientist. I have been certified and working with all Microsoft products. I have been building custom ACCESS Databases for 30 years More

£150 GBP in 1 day
(10 Reviews)
5.8
ammar3215

I am expert in excel and in access with 10 + years of experience , I can surely get the excel data into access as per your requirements mentioned , kindly message me

£20 GBP in 1 day
(10 Reviews)
4.7
goswamiarpit475

Hello, I have 10+ uears of experience in application programming. I can build an utility which will insert data from excel into access table with all the data manipulation logic. Please have a look at my profile for More

£20 GBP in 7 days
(21 Reviews)
4.8
vw1514518vw

Hi : one excel file --> 2 access tables joined by a relation/key constraints ..., I know exactly what you mean and i know how to code this, to import the excel data correctly to the 2 access tables having a relationshi More

£30 GBP in 1 day
(19 Reviews)
4.7
teekayzitsi

Hi In my current Profession -I perfom the DBA and Developer duties in high traffic OLTP environment -Data Mining ,Data Science,Machine Learning -Python programing -data analysis using python and R -Data Scraping us More

£20 GBP in 7 days
(36 Reviews)
4.7
SandelaSolutions

Hi - I can assist with your project. I regularly prepare Excel data for import into Access, which has various tools one can use for getting the data into the right tables, correctly. It would be great to have a look More

£20 GBP in 1 day
(12 Reviews)
4.6
mwikalicarolyne2

Hello! I have vast experience in Excel, Microsoft Access, SQL and Visual Basic, and I am confident that I can produce quality content for you that will be of interest to your readers. I am available for a full-time wr More

£10 GBP in 1 day
(1 Review)
4.0
jinc772

Hi there I have rich experience in converting from excel to access I am familiar with VB Looking forward to hearing from you Best Regards

£15 GBP in 3 days
(4 Reviews)
3.8
Maherun75

"""Dear employer, I had read your requirement for ""Code to import flat file from Excel to Access then split into related tables"". I am an expert in this field. That's why I placed my bid on this project. I'm a profes More

£15 GBP in 1 day
(16 Reviews)
4.1
Emajoe1

Hi, Honestly i am new to this freelancing world and also in data entry world. I have successfully learned 10+ online courses/ learning materials. Now this is the time to enter freelance and spread my works all ov More

£10 GBP in 3 days
(1 Review)
1.0
SmaMahmoud

Hello, I have an excellent experience with Python, HTML, CSS, SQL, and JavaScript(+5 years), it will be very easy for me, as I can do this task in a python desktop application by GUI, or Console. I can start now and de More

£10 GBP in 1 day
(1 Review)
1.0
roshan219124

Dear I am a REVERSE ENGINEER, and have a plenty of experiences in programming of Hex editores. and programs such as Winhex, CheatEngine, KernelDetective, ollydbg, x64dbg, Android, x86/x64Assembler, assembly, EXCEL VB More

£15 GBP in 7 days
(2 Reviews)
0.5
soniayt7

HhI I am experienced in and I can start right now but i have few doubts and questions lets have a quick chat and get it started waiting for your replyyy

£15 GBP in 7 days
(0 Reviews)
0.0
AKS261

I am a seasoned healthcare professional with more than 8 years of experience in healthcare industry. Well versed with the healthcare terminologies, policies, market outlook and patent segmentation. Done many projects f More

£15 GBP in 7 days
(0 Reviews)
0.0