Updating access spreadsheet

Is the problem I have related to the fact the Excel file is a "Template"......which is after completion saved under a different name ?

Many Thanks Bill, Welcome to the Lounge as a new poster.

Hello, I have a spreadsheet that already contains specific labels (headings, company logo, etc), that I would like to periodically update with information that is located within an Access Database.

I tried using a command button to have it print the data out into excel (based on a report I designed in Access); it works just fine to output the data into a spreadsheet, but it will not keep the labels that I put in my access report.

Therefore, I am wondering if there is another way that I could have access take the data from the database and update the original spreadsheet so it will maintain the proper labels (headings, logos, etc.).

I need to make this easy, because the end users are not really very computer savvy..help would be greatly appreciated. Have you tried to use the Data - Import Data - New Database Query function inside excel.

Yes, if you use a different name each time you will have to change the file name in the update query.

HTH BTW: It is proper Lounge etiquette to start a new thread with a new question and not add on to an existing one.

Transfer Spreadsheet function in Access, usually run on a form's "Timer" so I don't have to remember to run it periodically, to create a spread-sheet (we call them "Reference" spread-sheets) that is not the one that the user actually looks at, but which the one the user looks at points to for data.

The active spread-sheet that the user looks at can be highly formatted, but refresshing it after the reference spread-sheet has been created gives the user current data.

Note the XLS file is the last graphic but I should have posted it first. In an Excel (2010) Template I have a linked tbl to the Access Dbase.

I would like to enter a date into the Excel Date Completed field in the Excel linked tbl and have it update the Access Date completed field.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site.

609 Comments

  1. Fonte la presenza dell’etichetta cc nei risultati di ricerca contrassegna la presenza di sottotitoli (closed captions) e troviamo lo devo subito tirare fuori perch non resisto.

  2. Anonimo ha commentato: Rossella rasi moglie troia e infermiera molto porca „ Anche mia moglie l'ha preso per bene prima di tornare a casa da me..vedeva anche all'ospedale con un infermiere, ma l'ha scopata a casa sua ...

  3. If you're interested in using dating sites online, you know that most of them have the same people over and over again. The women on this site are sexy women from Lviv who are looking for a foreign man just like you who can show them a different part of the world and an exciting new lifestyle.

  4. Remember that we are the largest free online dating service, so you will never have to pay a dime to meet your soulmate. Don't expect him to act like a boyfriend, or anything more than civil and horny, he'll stick around. You got worried he was saying he might actually want a relationship but you don't want to commit right now.

  5. Featuring mobile chat rooms as well, helps you find and connect with single women and men throughout the globe.

  6. However, students with mental illness may experience symptoms that interfere with their educational goals and that create a "psychiatric disability." These symptoms may include, yet are not limited to: A student with a mental illness may have one or more of the following psychiatric diagnoses (American Psychiatric Association, 1994). Bipolar affective disorder (BAD, previously called manic depressive disorder).

Comments are closed.