PC Review


Reply
Thread Tools Rate Thread

Re: Macro to inport excel file to table in access 2007

 
 
Ken Snell [MVP]
Guest
Posts: n/a
 
      23rd Jul 2009
Use TransferSpreadsheet macro action. It has arguments into which you can
put constants that identify the file name with path, etc.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


"Leanne" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello there
>
> I'm trying to create a macro to import an excel file that regularly needs
> importing.
>
> How can i create a macro that will import the same file without having to
> find the file location each time the macro is run and without having to
> enter
> that it is to append a table that already exists?
>
>



 
Reply With Quote
 
 
 
 
Leanne
Guest
Posts: n/a
 
      23rd Jul 2009
TransferSpreadsheet isnt showing in the drop down list for macro action

In the help files it is menioned but it isnt showing. is there a reason for
this?

"Ken Snell [MVP]" wrote:

> Use TransferSpreadsheet macro action. It has arguments into which you can
> put constants that identify the file name with path, etc.
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
> http://www.accessmvp.com/KDSnell/
>
>
> "Leanne" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hello there
> >
> > I'm trying to create a macro to import an excel file that regularly needs
> > importing.
> >
> > How can i create a macro that will import the same file without having to
> > find the file location each time the macro is run and without having to
> > enter
> > that it is to append a table that already exists?
> >
> >

>
>
>

 
Reply With Quote
 
 
 
 
Ken Snell [MVP]
Guest
Posts: n/a
 
      23rd Jul 2009
You need to "Show All Macros". See this help article for more information.
http://office.microsoft.com/en-us/ac...142021033.aspx

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


"Leanne" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> TransferSpreadsheet isnt showing in the drop down list for macro action
>
> In the help files it is menioned but it isnt showing. is there a reason
> for
> this?
>
> "Ken Snell [MVP]" wrote:
>
>> Use TransferSpreadsheet macro action. It has arguments into which you can
>> put constants that identify the file name with path, etc.
>>
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>> http://www.accessmvp.com/KDSnell/
>>
>>
>> "Leanne" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > Hello there
>> >
>> > I'm trying to create a macro to import an excel file that regularly
>> > needs
>> > importing.
>> >
>> > How can i create a macro that will import the same file without having
>> > to
>> > find the file location each time the macro is run and without having to
>> > enter
>> > that it is to append a table that already exists?
>> >
>> >

>>
>>
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inport per-designed Word form into Access Reports =?Utf-8?B?SmFjcXVlbGluZQ==?= Microsoft Access Reports 8 11th Nov 2005 05:28 PM
Inport a large table into a smaller one =?Utf-8?B?TWlrZSBCdXNjaA==?= Microsoft Access 1 22nd Jul 2005 09:16 PM
Inport into access Stefan Gutten Microsoft Access 1 13th Sep 2004 06:01 PM
Inport into Access 2000 a Pervasive SQL 2000 Database ?. Bill Microsoft Access External Data 2 16th Jun 2004 05:02 AM
Delete and inport new records into an existing table Brian Microsoft Access External Data 9 17th Feb 2004 12:56 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:13 PM.