 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / June 2007Importing data design
I am trying to figure a way out to make a table that will import data in this format. http://www.drf.com/entries/24/eCPW24.html?rn=500027 I was able to import this through excel but trying to see if there is a way to make each a category. When I import it into access table I get the default field that has the following all in 1 cell. Entries CHIPPEWA DOWNS Sunday, June 24, 2007 Jump to race: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 1st (Post time 1:30) 5 1/2 Furlongs | Open | 3 Year Olds And Up Allowance | Purse: $2,500 Is there a way to make each of these into a cell? Consider using a two-step process... Step one - import 'as is' (or maybe even just link to the spreadsheet). Step two - use query(ies) to parse the data from the 'as is' into more permanent Access tables. This requires you to set up those permanent tables, but you'd want to do that anyway, to get your data well-normalized. Otherwise, you're just committing spreadsheet on Access... Regards Jeff Boyce Microsoft Office/Access MVP >I am trying to figure a way out to make a table that will import data in >this [quoted text clipped - 18 lines] > > Is there a way to make each of these into a cell? I will try this out tonight and let you know. Thank You > Consider using a two-step process... > [quoted text clipped - 34 lines] > > > > Is there a way to make each of these into a cell? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.