1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Access data export into Excel as the data linked to excel.

Discussion in 'Business Applications' started by vinwin06, Oct 19, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. vinwin06

    vinwin06 Thread Starter

    Joined:
    Jul 28, 2010
    Messages:
    413
    Hi,

    I want to know how i can export the data from Access to excel using Access VBA for the specified sheet using data linkage with access database. Like we used to do it manually in excel as external data from access.

    So that the excel size won't be that big and also it saves processing time.
     
  2. vinwin06

    vinwin06 Thread Starter

    Joined:
    Jul 28, 2010
    Messages:
    413
    Hope my question clear to all....
     
  3. vinwin06

    vinwin06 Thread Starter

    Joined:
    Jul 28, 2010
    Messages:
    413
    Hi OBP,

    waiting for your help in this thread also...
     
  4. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,667
    Sorry I don't see the point in using VBA for a one time Link from Excel to an Access table or query, that is if there is code to do it.
     
  5. vinwin06

    vinwin06 Thread Starter

    Joined:
    Jul 28, 2010
    Messages:
    413
    But how come its possible bcoz in my other thread we have codes for exporting into excel. but this one is just link the table with specific excel file only know......
     
  6. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,667
    Which version of Access are you using?
    As later versions have macros for that sort of thing, which can be converted to VBA.
     
  7. vinwin06

    vinwin06 Thread Starter

    Joined:
    Jul 28, 2010
    Messages:
    413
    I am using access 2007.
     
  8. vinwin06

    vinwin06 Thread Starter

    Joined:
    Jul 28, 2010
    Messages:
    413
    so its possibility of having this feature available in latest version?
     
  9. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,667
    No I think it is Access 2010, I can't find anything in Access 2007 macros.
     
  10. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,667
    I think you can however Link to an Access query from Excel using VBA.
     
  11. vinwin06

    vinwin06 Thread Starter

    Joined:
    Jul 28, 2010
    Messages:
    413
    ok OBP i too tried in google but not able to find out anything. Bad luck for me... its ok i will mark as solved...
     
  12. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,667
    Why not link from Excel, that is the normal way to do it?
     
  13. vinwin06

    vinwin06 Thread Starter

    Joined:
    Jul 28, 2010
    Messages:
    413
    yeah but every time the database name will change know thats why if i create it in db itself then i can create it easily by having a excel template.
     
  14. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,667
    Why does the database name change?
     
  15. vinwin06

    vinwin06 Thread Starter

    Joined:
    Jul 28, 2010
    Messages:
    413
    when i use it for monthly data i need to change the month in name of the data base know....
     
  16. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1073233

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice