Export data from Access to Excel-VBForums
Results 1 to 5 of 5

Thread: Export data from Access to Excel

  1. #1

    Thread Starter
    Member
    Join Date
    Apr 2008
    Posts
    35

    Export data from Access to Excel

    I need to export data from Excel 2007 file to Access 2007 table.

    The excel file has 65536 rows and I am not able to export more than 65536 rows of data.

    Here is the code

    con= "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" & DBName & "';"

    sql1= "INSERT INTO table SELECT * FROM [Sheet1$] IN '" & ThisWorkbook.FullName & "' 'Excel 12.0;'

    Please assist.

    I need to export data to Access from excel having more than 65536 rows of data

  2. #2
    Super Moderator Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,334

    Re: Export data from Access to Excel

    Moved To Office Development
    Please use [Code]your code goes in here[/Code] tags when posting code.
    When you have received an answer to your question, please mark it as resolved using the Thread Tools menu.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    I dont answer coding questions via PM or EMail. Please post a thread in the appropriate forum section.

    Creating A Wizard In VB.NET
    Paging A Recordset
    What is wrong with using On Error Resume Next
    Good Article: Language Enhancements In Visual Basic 2010
    Upgrading VB6 Code To VB.NET
    Microsoft MVP 2005/2006/2007/2008/2009/2010/2011/2012/Defrocked

  3. #3
    Super Moderator Siddharth Rout's Avatar
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    11,920

    Re: Export data from Access to Excel

    Quote Originally Posted by Sowjanya_N View Post
    I need to export data from Excel 2007 file to Access 2007 table.....
    I need to export data to Access from excel having more than 65536 rows of data
    You have me confused

    You thread title say you want to export data from Access to Excel and your thread says the opposite... which one do you want?

    Excel ~~>Access
    OR
    Access~~>Excel
    The poster formerly known as koolsid
    A good exercise for the Heart is to bend down and help another up...
    Please Mark your Thread "Resolved", if the query is solved

    Microsoft MVP: 2011 - Till Date IMP Links : Acceptable Use Policy, FAQ

    MyGear:
    Sony VGN-FZ27G with a triple boot between (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008) and (Win7+Office 2010+VS2010) || Sony VPCCB-45FN with a Win7+Office 2010+VS2010. VM: (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008), (Win8+Office 2010+VS2012) || Mac Book Pro (10.6.8) with Office 2011

  4. #4
    Frenzied Member kaliman79912's Avatar
    Join Date
    Jan 2009
    Location
    Ciudad Juarez, Chihuahua. Mexico
    Posts
    1,785

    Re: Export data from Excel to MS Access Table

    If the excel file has 65536 rows, why do you need to export more than that?
    More important than the will to succeed, is the will to prepare for success.

    Please rate the posts, your comments are the fuel to keep helping people

  5. #5
    Super Moderator Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,334

    Re: Export data from Access to Excel

    Duplicate Threads Merged

    Please do not create multiple threads, in different forum sections, for the same question.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    When you have received an answer to your question, please mark it as resolved using the Thread Tools menu.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    I dont answer coding questions via PM or EMail. Please post a thread in the appropriate forum section.

    Creating A Wizard In VB.NET
    Paging A Recordset
    What is wrong with using On Error Resume Next
    Good Article: Language Enhancements In Visual Basic 2010
    Upgrading VB6 Code To VB.NET
    Microsoft MVP 2005/2006/2007/2008/2009/2010/2011/2012/Defrocked

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.