Re: [MS_AccessPros] Convert Spreadsheet to database

 

Jim-

You would probably need to write some code to import the unnormalized data and then spit it out into the correct tables.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On May 23, 2014, at 6:28 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John, One of the spreadsheets has all of the information except for the tblTasksActivity data. The data is downloaded each week. Should I break out the data into the tables you describe? When I do a download, how would I replace the data to match the information in the tblTasksActivity table? Thank You Jim Wagner Sent from Yahoo! Mail for Windows 8 From: John Viescas JohnV@msn.com [MS_Access_Professionals]<MS_Access_Professionals@yahoogroups.com> Sent: ‎Fri, ‎May‎ ‎23‎, ‎2014 at ‎5‎:‎40‎ ‎AM To: <MS_Access_Professionals@yahoogroups.com> Subject: Re: [MS_AccessPros] Convert Spreadsheet to database Jim- Probably not. I assume you already have Supervisor and Department tables. You also need an Employees table. tblTasks: TaskID Supervisor ID Department ID Task Type tblTasksEmps: TaskID EmployeeID (If you want to limit to 2 employees per task, you'll have to write code to disallow adding a third employee to a task.) tblTasksActivity TaskID YearMonth Activity (I assume there's something in the intersection of months and tasks.) If an activity needs to be tracked by employee, then you'll also need an EmployeeID in tblTasksActivity. John Viescas, Author Microsoft Access 2010 Inside Out Microsoft Access 2007 Inside Out Microsoft Access 2003 Inside Out Building Microsoft Access Applications SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) On May 23, 2014, at 2:12 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote: I am trying to convert a spreadsheet with the months as columns across the top and names on the left and the data for each month pertaining to the names would be check boxes. There would be a need for years obviously. Do I create a table with each of the months as one field or each month being its own field? I just cannot picture it in my head. the fields would needed are Supervisor ID (is a number assigned to the Supervisor) Department ID (is a number assigned to the Department) Employee Name 1 (there are 2 employees assigned to a task) Employee Name 2 (there are 2 employees assigned to a task) Task (the name of the task) Type (the task type) Month (the month the task was completed) Thank You for any assistance Jim Wagner Sent from Yahoo! Mail for Windows 8

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___