Exporting fields from access to excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hi,

i know that it is possible to export data from Excal to Access and make sure
the data falls into specific fields, but can it be done the other way round?

I.e. can i have a preset spreadsheet with my fields designed, I click a
button (either or excel or access) then those fields becoem populated with
access info and there is no need for editing etc...
.



Relevant Pages

  • Re: Unable to edit a pasted excel 2007 object in word 2007 directl
    ... In Word 2007, when editing an excel object pasted into a document, when I ... The excel object itself has a semi-transparent, light blue border frame ... is happening and how do I change it so that the objects all pasted in edit ...
    (microsoft.public.office.misc)
  • RE: Path/File access error (Error 75)
    ... were created from the forms toolbar in excel 97. ... "Tom Ogilvy" wrote: ... Essentially rebuild the workbook in xl2003. ... then it is unprotected and a user form is opened to allow editing of values. ...
    (microsoft.public.excel.programming)
  • Re: Edit the rule description-how can u see a long formula in its enti
    ... And why haven't they changed it to default to the more logical editing mode the F2 changes it to? ... I don't understand why they (the Excel developers) thought this behavior was a *good idea*. ... *Before* you start using the directional arrows to navigate the formula hit function key F2. ... under the Edit Formatting Rule box there ...
    (microsoft.public.excel)
  • Re: Unable to edit a pasted excel 2007 object in word 2007 directl
    ... Usually, when using Word 2007 and pasting an excel 2007 object into it, the ... edit the object while right clicking and selecting various options. ... the excel 2007 editing options on it. ...
    (microsoft.public.office.misc)
  • Re: End line within a cell
    ... ALT+ENTER is in the "Keys for entering, editing, formatting, and calculating ... Microsoft MVP (Excel) ... determines how the wrap is handled. ... cell, and start new lines within the cell for each item in the list. ...
    (microsoft.public.excel.newusers)