I have attached a copy of my excel spreadsheet. What I am trying to do is take the information I get from the coloumns in the spread sheet and build a database that i can send that information to when I click a command button.
if the sheet is password protected the pass word is hi
Picking log-Rev6.xlsm
With the format you have, it will be very difficult to import the data into an Access database. You will need to restructure the data into a normalized manner. Look at the link in my signature for a link on data normalization within a relational database management system. You have repeating fields which won't work in a rdms.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
what if I wanted to send the info from the total minutes picked sheet to access? would this be possible?
This would be nightmarish. You would need to normalize your data. Probably in this mannerwhat if I wanted to send the info from the total minutes picked sheet to access? would this be possible?
RecordId
NameField
ShiftField
MinutesField
In this manner, your data will be normalized. Easily imported/linked and easily queried.
Have you checked my total minutes sheet on my sample? is this the correct set up?
No. It needs to be just the four fields I indicated in my earlier post. Have you read the link in my signature on Normalization? You have repeating data fields. Read up on the normalization. It is critical to database management. It is different from a spreadsheet mindset.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks