Re: [baseball-databank] Newbie Question
- Sean Lahman has most of the DB at www.baseball1.com in
--- Jim Kern <jimkern@...> wrote:
> Is there any easy way to pull this data into either__________________________________
> Access or SQL
> Server? Those are the DB engines I am familiar with
> and have at my
> disposal...any hints?
> ------------------------ Yahoo! Groups Sponsor
> Yahoo! Groups Links
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25�
With a little tweaking, you can edit the mySQL create table statements to be compliant with SQL Server. I have most of the data sitting on SQL Server.
For the most part, if I remember correctly, I just removed the unlimited statement, changed int(x) and smallint(x) to int and smallint, and put brackets around fields that started with a numeral. (There may have been a couple more, but nothing significant.
After that, it was simple csv import.
From: Jim Kern [mailto:jimkern@...]
Sent: Wednesday, April 21, 2004 11:20 AM
Subject: [baseball-databank] Newbie Question
Is there any easy way to pull this data into either Access or SQL
Server? Those are the DB engines I am familiar with and have at my