INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

How to code to transfer data from ms access to excel worksheet

How to code to transfer data from ms access to excel worksheet

(OP)
Hi,

I hope someone can help me with this.

I have an access table with one single row data, I would like to transfer this to an existing excel worksheet, and then copy&move that worksheet to a new workbook break the link and then save it to a specific path folder naming as "Transit 0000.xls" I would like this actual transit number(0000) to come from a text box in the form where I type the transit nummber.

I would like to put this code under a command button in access form.

Please let me know what further information you need.

Thank you for all your help.

 

RE: How to code to transfer data from ms access to excel worksheet

What have you tried so far?

HarleyQuinn
---------------------------------
You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers: How to get the best answers before posting.

http://lessthandot.com

RE: How to code to transfer data from ms access to excel worksheet

(OP)
Hi HarleyQuinn,

I was looking for the code to transfer data from access to excel I only found how to transfer data from excel to access. I also ran the macro in excel to copy&paste teh excel worksheet to a new worksheet and break the link but this macro I can get it to work under the code for the button in acces form.

Thanks.

RE: How to code to transfer data from ms access to excel worksheet




Hi,

Check out CreateObject and GetObject in VB Help.  Good examples, so that you can manipulate Excel objects from Access.

Skip,
glassesDon't let the Diatribe...
talk you to death!tongue

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: How to code to transfer data from ms access to excel worksheet

Have you tried to create an Access macro which uses the OutputTo function?   

RE: How to code to transfer data from ms access to excel worksheet

(OP)
Hi GhostWolf,

No I have not tried that. I will give that a try.

Thanks.

Have a Great Weekend! :)

 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close