Excel To database (1 Viewer)

[zezo2021]

friends

the attached file contains data I want to load these data to the database
I face some problems
convert these data in excel to columns in the database

Report By
Department Head
extract date form title into 2 parts (from-to)
Department Name
unplanned Tasks
Convert Days to Columns and rows beside the task and crew

any help is appreciated

 

[zezo2021]

up

 

[Uncle Gizmo]

You may find my blog here helpful:-

Excel in Access - Nifty Access

Excel in Access - Problem & Solution! One of the most frequent problems I see is people confusing MS Access with Microsoft Excel. This leads to fundamental design errors. Now, the problem is, this error "A Major Error" does not become apparent straight away. Unfortunately your database will work...

www.niftyaccess.com

To get a free copy of the "Transpose Tool" contact me by the private messaging system on this forum and I will explain how you can get a free copy.

 

[arnelgp]

i am hoping you only have 1 format /template for your weekly excel report.
see if this will help.
it will be save into two tables (header/details).