Results 1 to 7 of 7

Thread: Article: Export A Range Of Excel Data To A Database

  1. #1
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,195
    Articles
    57
    Blog Entries
    14

    Article: Export A Range Of Excel Data To A Database



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #2

    Always get error message

    Dear colleagues,

    I'm trying to use mentioned vba, but it's not working for file. Could any of you check what I am doing wrong? I'm truly desperate for help.

    New Product-Operation Request.xlsmNew Operation Renan2.mdb
    Thanks Renan

  3. #3
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    Two possible errors.
    • A reference must be set to the Microsoft ActiveX Data Objects Libary
    • What version are you using, connect string above uses oledb.12. Open explorer, browse to office and I'm guessing yours is 10. If so change 12 to 10 and should work fine

  4. #4
    Thanks, error was at string set.
    Simple tip to solve it.
    Tks

  5. #5
    Hi Friend I have a question I'm using Office 2007, has a line border to send? I did a test and only sends 8 lines.

  6. #6
    [QUOTE = WizzardOfOz; 9139] Dois erros possíveis.
    • A referência deve ser definido para o Microsoft ActiveX Data Objects Libary
    • Qual versão você está usando, conecte corda acima usa oledb.12. Abrir Explorer, navegue até o escritório e eu estou supondo que o seu caso é 10. Se assim for mudar 12-10 e deve funcionar bem

    [/ QUOTE]

    Hi Friend I have a question I'm using Office 2007, has a line border to send? I did a test and only sends 8 lines.

  7. #7
    Hi Ken,

    I am unable to add excel data to access table which is linked to sharepoint list. When I open access and try to open the table, I get a warning message "The setting you entered isn't valid for this property". Because of this warning, the above query is not executing.

    How to disable warning while opening the table? Could you please let me know the code and where to insert it in the above code.

    Thank you.

Posting Permissions

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