importing schedule and data into the SQL database | Peter's Sports League Standings | Forum
Back to the sports standings script page
Log In
Home
Topic RSS
6:30 pm
I have in access a database that can populate the sportsdb_wins table. The only problem is I can't import the date and times. They are formated as date/time in access. I am not sure of what the format of the windate field is nor do I know what the format of the wintime field is. I have about 500 records. It would be nice to be able to bring these in from access directly into the sql fields.
I have spent a great deal of time looking for a solution on google and I don't understand how many of the solutions I found work.
I am sorry if I seem a bit thick but really simple step by steps would help.
Thanks
12:23 pm
Offline
Hi Mark,
Dates in the sports standings program are formatted as Unix timestamps. Basically, a Unix timestamp is the number of seconds since seconds January 1, 1970 for a particular date. For an idea on what these look like, see this post and enter some times into the generator.
There is probably an "export" function from Access. From there, you will have to massage the data to fit the data types of the destination database fields. There are many ways to do this -- from importing into a separate MySQL table first, to manually working on the exported Access data to make it conform (this is probably best).
There might be a specific step-by-step process for your situation, but for that I or someone else would have to look at your Access database to see what's there, in what format, and what you want to import.
