If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
import excel data to access
HI
I apology since this may not be the best group to ask this question: I have excel spreadsheets that I am trying import into tables to be able to utilize Access for reporting I do not have access to the original data from which the spreadsheets were created. The spreadsheets contains data from several hundred stores, and for each store had several seasonal category sales. Each Spreadsheet would contain the sales totals (to-that-date) for each store(row) and then 3 cols of data for each category (the 3 cols , Sales $, % of sell thu, units remaining). For the same year/season the spreadsheets are usually indentical, for each season 5 to about 20 categories (cols) and 3 different info (Sales $, % of sell thu, units remaining) for each Category. Christmas for example would have the most categories. (Seasons would be like Valentines, Easter, Xmas, Summer, etc) Each year the spreadsheets are slightly different (most of catergories are same) however due to store closing/openings stores may not be indentical and to further complicate things last year a few dozen stores were also were numbered (atlhough I could probably modify the spreadsheets to fix that or ad a table show old/new #'s) Each season I have about about 10-20 sheets , and each sheet in the running total for that date.(for example for Xmas I might have a sheet Xmas121504 and Xmas122004, the sheet for Xmas121504 might have $1,000 for XmasTrees for Store 123 and for Xmas122004 it might be $1,500 both of which are running total for the date the sheet was created. I have exported things to Excel from Access and worked with data that way which some things are easier in Excel but I havent really imported to Access from Excel and I am not sure where to begin....I am trying to figure out a plan of how to go about this with the least amount of time and labor. I could like tables to each spreadsheet or import the data several ways. What I was sort of thinking of creating tables Seasonal Categories (the names and SeasonaCatID) for each category for each Season Seasonal Names(The names and SeasonNameID) for each season Seasonal Detail(Table with seasonal detail) I could modify each spreadsheet to have season code and date col to import StoreNum (this would have store #, District, Region info for store #'s ) to be able to do reports by Dist/Reg/Store Can someone tell where I can find examples and offerr some suggestions of how to go about this? One I get the data imported to tables I can work with it thanks Kevin |
#2
|
|||
|
|||
Quote:
|
#3
|
|||
|
|||
Kevin,
About 5 posts below this, is another post titled Table(s) Design. In Jeff Boyce's response, he offers a very good suggestion for how to go about determining what design you might want to begin with, for a database. Good luck. Sharkbyte "Kevin Labore" wrote: HI I apology since this may not be the best group to ask this question: I have excel spreadsheets that I am trying import into tables to be able to utilize Access for reporting I do not have access to the original data from which the spreadsheets were created. The spreadsheets contains data from several hundred stores, and for each store had several seasonal category sales. Each Spreadsheet would contain the sales totals (to-that-date) for each store(row) and then 3 cols of data for each category (the 3 cols , Sales $, % of sell thu, units remaining). For the same year/season the spreadsheets are usually indentical, for each season 5 to about 20 categories (cols) and 3 different info (Sales $, % of sell thu, units remaining) for each Category. Christmas for example would have the most categories. (Seasons would be like Valentines, Easter, Xmas, Summer, etc) Each year the spreadsheets are slightly different (most of catergories are same) however due to store closing/openings stores may not be indentical and to further complicate things last year a few dozen stores were also were numbered (atlhough I could probably modify the spreadsheets to fix that or ad a table show old/new #'s) Each season I have about about 10-20 sheets , and each sheet in the running total for that date.(for example for Xmas I might have a sheet Xmas121504 and Xmas122004, the sheet for Xmas121504 might have $1,000 for XmasTrees for Store 123 and for Xmas122004 it might be $1,500 both of which are running total for the date the sheet was created. I have exported things to Excel from Access and worked with data that way which some things are easier in Excel but I havent really imported to Access from Excel and I am not sure where to begin....I am trying to figure out a plan of how to go about this with the least amount of time and labor. I could like tables to each spreadsheet or import the data several ways. What I was sort of thinking of creating tables Seasonal Categories (the names and SeasonaCatID) for each category for each Season Seasonal Names(The names and SeasonNameID) for each season Seasonal Detail(Table with seasonal detail) I could modify each spreadsheet to have season code and date col to import StoreNum (this would have store #, District, Region info for store #'s ) to be able to do reports by Dist/Reg/Store Can someone tell where I can find examples and offerr some suggestions of how to go about this? One I get the data imported to tables I can work with it thanks Kevin |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 06:36 AM |
import access data into excel cells? | cory | General Discussion | 1 | October 6th, 2004 08:04 PM |
Upload Image | Jason MacKenzie | General Discussion | 1 | September 1st, 2004 04:38 AM |
Importing Excel spreadsheet into Access - data type problem | Andrew Good | General Discussion | 2 | August 27th, 2004 09:39 AM |