Results 1 to 6 of 6

Thread: Quattro to any SQL DB question...

  1. #1
    Maximum Bitrate PoBoy's Avatar
    Join Date
    Jun 2001
    Location
    St. Louis-MO
    Posts
    490

    Quattro to any SQL DB question...

    Anyone know how easy it is to take a Quattro spreadsheet and turn it into a table in any SQL DB software? Basically, is there something out there that allows you to cut and paste field entries (or just import) from a spreadsheet into a SQL Table.

    PoBoy
    I'm a ghost...email me if you have any questions on my old setup

    My way outdated website: http://www.poboytech.net

    FYI: I sold my 96 4Runner and bought a 1985

  2. #2
    Self proclaimed spoon feeder TruckinMP3's Avatar
    Join Date
    Jun 2002
    Location
    Colorado
    Posts
    2,742
    You should be able to save the current spreadsheet as comma delimited. Then Import the comma delimited file into the new database.


    Hope that helps.

    TruckingMP3
    TruckinMP3
    D201GLY2, DC-DC power, 3.5 inch SATA

    Yes, you should search... and Yes, It has been covered before!

    Read the FAQ!

  3. #3
    Variable Bitrate
    Join Date
    Nov 1999
    Location
    Ishoej, Denmark
    Posts
    310
    If you use the comma separated files you MUST be sure that you dont use commas ANYWHERE in the text. if possible use make the delimiter a sign you didnt use.

    If Quatro doesnt allow you to do this then try importing it into excel in the native format (excel might understand this format), and then use excel to make the simple text file with a delimiter of your choise (i recommend ; but be careful and make sure that the sign is not in any of the fiels AT ALL)

    Hope this helps

  4. #4
    Maximum Bitrate PoBoy's Avatar
    Join Date
    Jun 2001
    Location
    St. Louis-MO
    Posts
    490

    Import...

    I think I understand the file creation process...but how about the import. Im used to Unix, but have to use a MS compatible DB software. What database software ie SQL Server, would be best to import with? I DLed MYSQL, didnt see an import option, but maybe I missed it. I assume that I have to create the DB first then import the fields into it.

    Basically what I have are 3 spread sheets full of names, dates, etc. I want to build a DB out of it, add new fields, and build some php pages.

    Thanks,
    PoBoy
    I'm a ghost...email me if you have any questions on my old setup

    My way outdated website: http://www.poboytech.net

    FYI: I sold my 96 4Runner and bought a 1985

  5. #5
    Self proclaimed spoon feeder TruckinMP3's Avatar
    Join Date
    Jun 2002
    Location
    Colorado
    Posts
    2,742
    I would use access, but only because I have it and already know it. It has a couple different ways to import: to a new table or existing. it can also impost from multiple file formats.

    I know other solutions are out there, see if mySQL has other import functions. I have not worked with it.

    TruckinMP3
    TruckinMP3
    D201GLY2, DC-DC power, 3.5 inch SATA

    Yes, you should search... and Yes, It has been covered before!

    Read the FAQ!

  6. #6
    Newbie
    Join Date
    May 2002
    Location
    Hicktown, WI
    Posts
    6
    There should be a program called mysqlimport.exe in C:\mysql\bin.
    And more info on it here -http://www.mysql.com/doc/m/y/mysqlimport.html

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •