[KLUG Programming] SQL question

[Rusty Yonkers]

Ok... I have what you gurus are probably going to think is way to
easy but please be gentle ... I am still learning MySQL and SQL.

I have to extract data from a group of FileMaker databases and put
them ultimately into a MySQL database.  Some of the databases (think
dBase III where one database is one table) are really small and I
have been able to extract them both as an export and as an ODBC
connection into Access or Excel.  

The most important databases (of course) are huge though, both in the
number of fields and the number of records (well huge comparatively).
 One of the databases has >1400 fields in it.  About 400 fields are
calculation and summary fields that I do not need but have to deal
with in the conversion process.  FileMaker uses them for doing
calculations for reporting (no its report writer is not smart enough
for that!).  Another one is like 167 fields.  Access chokes on them
with ODBC and an export just is not reliable.  The FileMaker ODBC
driver is only available for Windows so I cannot use a Linux frontend
tool for pulling the data out.  

Is there some nice tool that would use ODBC to attach to the tables
that I could then use to move the data from the FileMaker tables into
the MySQL tables?  I initially need just to copy the data into MySQL
so that I can have a better way to look at what is there and also
setup some crude reporting capabilities to get us by while I work on
the new program.  I want to be able to do a nightly extraction if
possible so we can have near-realtime data reporting.  Down the road
I am thinking that I will want to take the extracted data and then
run a script that will actually move the different parts of the data
tables into the appropriate new tables when we are ready to convert
to the new program.  

I have read on the Web that the errors I am getting in Access are
because of limitations for numbers of fields in the program.  Excel
seems to handle it much better (although not perfectly yet as I am
working out the bugs).


=====
Russell C. Yonkers Jr. 
CNE, MCP, A+, CCNA, Linux+, Server+, Network+ certified
-----------------------------------------
Currently using SuSE 9, Mac OS X, Windows 2000, and WinXP 
And yes I run a network at home with Linux and Windows servers
See my personal website http://www.geocities.com/therustycook
Or my consulting site at http://www.atomicsupergeek.com


	
		
__________________________________
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/