Importing data design

[Steveo]

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?

 

[Jeff Boyce]

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

 

[Steveo]

I will try this out tonight and let you know. Thank You