[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 611
  • Last Modified:

convert census data to mysql

Hi

I wonder if someone can help me.
I need to get city census data into a mysql database.

Does anyone have experience with this task?
I am getting the datasets from here:

http://www2.census.gov/census_2000/datasets/

and really don't know where to begin.

Thanks
0
b1xx1b
Asked:
b1xx1b
1 Solution
 
wolfgang_93Commented:
It looks like you can navigate to pages that in turn list .zip files.

I would begin by doing a right-mouse click on one of these files
to save the file to my PC.
Then I would use a program like WinRAR or Zip to "unzip" it to see
how the data is organized (Excel spreadsheets? tst? csv format?)

Once I know the format, I would look at tools for uploading various
Formats into a DBMS such as MySQL.
0
 
b1xx1bAuthor Commented:
far too simple an answer.  Kind of stating the obvious.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now