+ Reply to Thread
Results 1 to 7 of 7

Excel to mysql import

  1. #1
    Registered User
    Join Date
    08-20-2022
    Location
    China Town, China
    MS-Off Ver
    2021
    Posts
    31

    Excel to mysql import

    Hey guys,

    sorry to post this one here, is there a better subforum for this question:

    I keep trying to import an excel file into mysql table. it is only adding about 130k, the file is around 256k. mainly they are barcode title publisher language. should be easy but why is mysql importing random qty and not all file?

    all data is sort and have the correct format.

    any help please? also if this is not where to ask for such thing, could you please guide me to another place?

    thanks again

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Excel to mysql import

    YOu have posted in the Access forum section - is this correct?

    Administrative Note:

    Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

    With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

    Thank you for helping us to help you.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    08-20-2022
    Location
    China Town, China
    MS-Off Ver
    2021
    Posts
    31

    Re: Excel to mysql import

    Hello Ali,

    I am sorry, could you please explain why I need to share my location?

    And yeah, I hope that someone with experience with access databases would be able to help me import a file into my sql.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Excel to mysql import

    I have explained in my note why. A broad indication is enough, as I have also explained. It's all in post #2.

    I have to say that I think you might be waiting a long time for help with this here, as we rarely get queries like this and I'm not sure how many members we have who are significantly versed in SQL. I am afraid I don't know where to suggest you look as it's not something I'm familiar with.

    However, I would suggest that you update your thread title to summarise the nature of the request, which is to do with the amount of data being imported and not the process itself. As it stands, it looks as if you want help with the process.

    Hope you get some responses.
    Last edited by AliGW; 07-25-2023 at 01:46 AM.

  5. #5
    Forum Contributor
    Join Date
    03-11-2021
    Location
    india
    MS-Off Ver
    365
    Posts
    154

    Re: Excel to mysql import


  6. #6
    Registered User
    Join Date
    08-20-2022
    Location
    China Town, China
    MS-Off Ver
    2021
    Posts
    31

    Re: Excel to mysql import

    hi Mingeita, thank you. I just did, it should work thx

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Excel to mysql import

    If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. mysql for Excel
    By wladoD in forum Access Tables & Databases
    Replies: 2
    Last Post: 12-26-2020, 03:27 AM
  2. Import data from MySQL automatically
    By Maggie123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2015, 09:57 AM
  3. How can i import data from excel csv into mysql
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2014, 05:53 AM
  4. Import from MySQL Problem
    By jacque427 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2007, 06:39 PM
  5. [SOLVED] How can I import data from a mysql database into excel
    By Tina in forum Excel General
    Replies: 3
    Last Post: 05-17-2006, 11:25 PM
  6. Using Excel for MySQL database import
    By inspireme in forum Excel General
    Replies: 1
    Last Post: 01-06-2006, 06:59 PM
  7. Import MySQL data to Excel
    By mbeyer in forum Excel General
    Replies: 0
    Last Post: 11-30-2005, 03:10 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1