HELP linking access table to excel
 

Ihave in access a table full of customers details and i want to link them in
excel (basic invoice)

bascly i want to click a button and it brings up the table so i can view
customers then i choose one and it enters all the deails in specific cells

can some one help me please!!!!

thanx in advance

HELP linking access table to excel
 

In Access, go into Macros, and click Action 'TransferSpreadsheet' Export
Spreadsheet Type (Microsoft Excel 8-10) Table Name (where spreadsheet is
coming from) File Name (path and name of your file) Has Field Names
(probably 'Yes') Rang (may want to leave blank; you decide). Finally, put
some name in the 'Comment' section just so you remember what you are doing
when you look at the Macro a while form now. You an easily convert this
Macro to VBA code and assign the code to a 'Command Button' on a 'UserForm'.
then, when you click the button, the code fires, and you get your desired
results.

Regards,
Ryan---

--
RyGuy


"greg" wrote:

Ihave in access a table full of customers details and i want to link them in
excel (basic invoice)

bascly i want to click a button and it brings up the table so i can view
customers then i choose one and it enters all the deails in specific cells

can some one help me please!!!!

thanx in advance

HELP linking access table to excel
 

when i do that it inserts the whole table including all the headings etc and
it also just puts them in a striagt line any more help?? to just select out 1
and to remove hedings and put them in designated cells???

"ryguy7272" wrote:

In Access, go into Macros, and click Action 'TransferSpreadsheet' Export
Spreadsheet Type (Microsoft Excel 8-10) Table Name (where spreadsheet is
coming from) File Name (path and name of your file) Has Field Names
(probably 'Yes') Rang (may want to leave blank; you decide). Finally, put
some name in the 'Comment' section just so you remember what you are doing
when you look at the Macro a while form now. You an easily convert this
Macro to VBA code and assign the code to a 'Command Button' on a 'UserForm'.
then, when you click the button, the code fires, and you get your desired
results.

Regards,
Ryan---

--
RyGuy


"greg" wrote:

Ihave in access a table full of customers details and i want to link them in
excel (basic invoice)

bascly i want to click a button and it brings up the table so i can view
customers then i choose one and it enters all the deails in specific cells

can some one help me please!!!!

thanx in advance

HELP linking access table to excel
 

If you are feeling really ambitious, you can take a look at this:
http://www.rondebruin.nl/accessexcel.htm

As an alternative, you may be able to 'customize' the action of transferring
your data. Look at my instructions form before. The last argument is called
Range. You can define the range, such as Sheet1!A10:M10. (this is the sheet
object and the range object). Give that a shot.


Regards,
Ryan---

--
RyGuy


"greg" wrote:

when i do that it inserts the whole table including all the headings etc and
it also just puts them in a striagt line any more help?? to just select out 1
and to remove hedings and put them in designated cells???

"ryguy7272" wrote:

In Access, go into Macros, and click Action 'TransferSpreadsheet' Export
Spreadsheet Type (Microsoft Excel 8-10) Table Name (where spreadsheet is
coming from) File Name (path and name of your file) Has Field Names
(probably 'Yes') Rang (may want to leave blank; you decide). Finally, put
some name in the 'Comment' section just so you remember what you are doing
when you look at the Macro a while form now. You an easily convert this
Macro to VBA code and assign the code to a 'Command Button' on a 'UserForm'.
then, when you click the button, the code fires, and you get your desired
results.

Regards,
Ryan---

--
RyGuy


"greg" wrote:

Ihave in access a table full of customers details and i want to link them in
excel (basic invoice)

bascly i want to click a button and it brings up the table so i can view
customers then i choose one and it enters all the deails in specific cells

can some one help me please!!!!

thanx in advance