[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[ale] OT: Data Mapping Tool



This is a pretty good question and a realistic need.  Sorry I don't know 
of any product that will do exactly that.  But ...... MySQL can import CSV 
file (or just about any other files).  You may find you need to seperate 
the columns in your spreadsheet.  Also PHPMyAdmin has great tool makes 
some of the import features easy to use.

If you data is on a Windows box you can can use ODBC and Excel.  I must 
admit Excel is one heck of a tool.  You'll at least need the ODBC driver 
for the DB your using.  You may also need an Excel data access plugin.

Good luck, I'll be curious to know if there is such a product which will 
do just what your looking for.
--
Brad

> I am in need of a tool that can handle a combination of importing and
> mapping data to a database.
> 
> Example of my problem would be this:
> 
> I have a spreadsheet of data that I wish to import into a database BUT..
> this spreadsheet really contains data that needs to be divided up into
> three or four different tables in my database.
> 
> 
> What I would like to be able to do is choose a delimited file to import
> and then choose the 'mapping schema' that matches my database. In other
> words, import data from one file into multiple tables that don't have the
> same field name or number of fields but do have the proper data types.
> 
> 
> Thanks for your help in advance, I have always received awesome answers
> back from this list. Keep up the great work :)
> 
> Kevin Stoll
> 
> __________________________________________________
> Do You Yahoo!?
> Try FREE Yahoo! Mail - the world's greatest free email!
> http://mail.yahoo.com/
> 
> ---
> This message has been sent through the ALE general discussion list.
> See http://www.ale.org/mailing-lists.shtml for more info. Problems should be 
> sent to listmaster at ale dot org.
> 


---
This message has been sent through the ALE general discussion list.
See http://www.ale.org/mailing-lists.shtml for more info. Problems should be 
sent to listmaster at ale dot org.