Data in Tables updates every 15 mins

I receive data every 15 mins in an Excel database format in the form of an 
attachment to an email..    

I would like to be able to use this file as a dynamic base file used in an 
ACCESS file/program.  

Any ideas on how to get this data in the email attachment into Access every 
15-30 mins automatically?  
0
Utf
1/1/2010 12:56:01 AM
access 16762 articles. 3 followers. Follow

1 Replies
905 Views

Similar Articles

[PageSpeed] 36

You will need to break this task into bite-sized chunks, and conquer each 
task. I would start by trying out Helen Feddema's sample:

     Saving Email Attachments to an Access Table  (See # 123)
     http://www.helenfeddema.com/access.htm

Hopefully, the structure of the spreadsheet remains constant (column names, 
position of columns, etc.). It will also be helpful if the spreadsheets 
include defined data ranges, which you can include as an optional parameter 
in DoCmd.TransferSpreadsheet method.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

"dadtofive" wrote:

> I receive data every 15 mins in an Excel database format in the form of an 
> attachment to an email..    
> 
> I would like to be able to use this file as a dynamic base file used in an 
> ACCESS file/program.  
> 
> Any ideas on how to get this data in the email attachment into Access every 
> 15-30 mins automatically?  
0
Utf
1/1/2010 1:23:01 AM
Reply:

Similar Artilces:

Mounting old Data Stores
Hi. Due to problems with Win2003 SBS, I did a reinstall of Win2003 SBS sp1 from original CD-s. Before 'deleting' the old Windows, I made an ASR tape backup of the running server. It seams the ASR backup backed up only drive C: with all relevant data. As other data were on drive D: (Exchange data files, SQL data files,...), I backed up the D: drive too to a separate tape in a separate ntbackup session. Before the backup I used Exmerge to export all users mailboxes. Later I imported those mailboxes in a new Exchange installation. Unfortunately the user forgot to told me, they hav...

Import external data-text files but placed in the next column rather than next empty row
I want to import text files in to one worksheet. The text files are sent daily and all the same format. However the text file names change buy an incremental number. Is it possible to create a macro that imports these text files, ignoring their exact filename but from the same source directory into one worksheet. Can you use wild cards for the name e.g. "********.txt"? At the moment I can manually do this, by selecting the cell below the last record then using the process "Get external Data" and following the wizard which works fine. As soon as I try to create a m...

Calculation 12-15-07
I design one form with TAB control I place sub form in tab control, the Sub form is base on datasheet view, I add one unbound control text field which enabled property set to NO, this control source property base on two other column value like I have two bound(Table) fields I want to show the addition of this field at runtime in this unbound field, every thing is perfect here but I also want SUM of this unbound feild in datasheet view, I try many things but It did not show sum of this unbound field, only Count function work(Total Row option in 2007) for this field even I set format to g...

Plotting 1 curve from 2 separate x-axis data
I have stock portfolio info for January thru June, which plots easily. After portfolio changes, I have another plot for July thru December. Plots easily. These data are on 2 separate worksheets. Now I would like to plot a single curve for the year. The first 6 months is easy. How can I plot a continuous curve for the whole year without having to insert the first 6 months worth on the last 6 months worksheet? Not sure I explained this very well, but --- Dave The easiest way is to have both sets of data on one (a new?) worksheet. Then you can plot as with one or two series. Copy a...

Why can't I find a table in the lookup wizard?
Using Access 2007, I need to create a lookup field for an existing table, but it is not listed when creating it. Jenni, I can't tell by your posting, are you trying to create a circular reference? Look-up field using the same table you are creating the field in? Well, I'm going to say it makes sense that it would not be in the list but let me know if that's what you meant. On another note... Look-up fields = Bad idea and here's why... http://www.mvps.org/access/lookupfields.htm -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been deni...

Re: Updating spreadsheets
Is there a way in Excel to take a spreadsheet containing new price adjustments, compare it to my current inventory, make price changes as necessary on my current inventory spreadsheet, and , then print a list of changed items? Or is this an Acess function? Thanks, Gary B gb20003@comcast.net Gary, take a look at the Data Loader at http://www.add-ins.com/dataload.htm. It will do most of what you want. It will color the cells that are loaded blue so that you can identify the ones that were updated. Bob Flanagan Macro Systems 144 Dewberry Drive Hockessin, Delaware, U.S. 19707 Phone: 302...

bulk updates/ price changes
Is there any software out there, compatible with RMS, that would allow us to do bulk updating of our items using an excel spreadsheet? We are looking for something fairly advanced that would enable us to do mass price changes based on supplier and item lookup codes. Also need to be flagged on new items and discontinued items. Know of anything that sounds similar? Thanks You can use text functions in Excel to generate a series of queries to do what you want to do. For example, if your columns are ILC, Supplier, Cost, Price and you want a query to update all items with a new price, you coul...

In Excell--- I want to rotate a table 90 degrees
I need to rotate a spreadsheet (11 x 8 1/2)landscape to be on a portrait (8 1/2 x 11). Is it possible to rotate a spreadsheet? you mean actually print it with what shows as the columns being the rows and vice versa? highlight the original table and as you have the last cell highlighted, note in the NAME box on the upper left the Row x Column numbers. Select a range on another sheet that is exactly the flip of those numbers (in other words, stretch until you get the Row x Column to be the Column x Row of the original size). When you have selected this new range, type =TRANSPOSE(hig...

CRM updates?
I just installed MS CRM 3.0, the demo version that was released a few months ago. I figured that surely there would be be updates, bug fixes, etc., but a visit to Microsoft Update did not find any. Questions: Have there been any updates? Is MS Update the place to find them? If not, where? MS Update will not update CRM. Since it's a business app, hotfixes are not automatically applied since many are only distributed when customers experience specific issues that require the hotfix. There is also a potential of some hotfixes requiring isntall on the client machines as well, so t...

Update 873262 Problem
The latest performance enhancement for the Outlook Sales client is 873262. The install instructions say to install the update on the client . . . while on the downloads page for this update, it only shows a server file. So which one is right? -- Brandon Smith IT Director Presentations Direct - Specialized Office Equipment & Supplies http://www.presentationsdirect.com I should have included the links: The download page is: http://www.microsoft.com/downloads/details.aspx?familyid=133a85d0-e3e3-4356-908d-9fb6e4fa3501&displaylang=en The KB page (w/ instructions) is: http://supp...

Junction Tables
I'm just curious if it makes sense to use junction tables in this instance: student - studentID, studentfirst, studentlast, gender, age (adult, teen, or child), lessonday, status (current or retired) address - addressID, address, city, province, postalcode phone- phoneid, phonenum, extension, phlocation email - emailid email, emailLocation gaurdian – gaurdianid, gaurdianfirst, gaurdianlast, relationship studentaddress - studentID, addressID studentguardian - studentID, guardianID GuardianAddress - guardianID, addressid Studentphone - studentID, PhoneID Guardian...

Frx: linked data worksheet summing error
We use linked data worksheets for some of our reporting. The column format displays both current period and YTD. The YTD column is not calculating the correct amounts from the worksheet. For example, if we were in period 12, it would sum the YTD column as follows. period 1: add 12x period 2: add 11x period 3: add 10x period 4: add 9x ....and so forth period 12: add 1x Obviously, this gives us a huge error in the ytd column. Anyone have an idea why this is occurring? We are using the /cpo format for the linked worksheet. Thanks ...

Help! Selecting data according to date range
I'm attempting to setup a worksheet for reminding employees to rene their licenses. I have input the data where the data range is from ro 3 - 84 (this could increase or decrease with hiring/firing, etc.). Th columns range from A - K with column H being *date*. I would like to start a new sheet (sheet2) in this workbook with th range of months in a year. In each monthly section it would search th data range in sheet 1 and return the records with the correspondin dates for that month. For example: If a employee's license expires i January, the entire record for that employee would...

How Check some cells have been updated
Hi All I want to keep trace some of cells in Row have been updated, the one of column update as today and time ? Does formula can handle this ? eg. A11 or B11 or C11 Updated, the D11 = today + time moonhkt Put this code in your worksheet module. To do this, right click the sheet tab at the bottom of Excel, click View Code, then paste code below into the sheet module. This code will put a time stamp in Col. D if any data is changed in columns A, B, or C. Give it a try. Hope this helps! If so, let me know, click "YES" below. Private Sub Worksheet_Change(ByVa...

Pivot Table chart field buttons
I have a pivot table chart with several field buttons across the top. How can I move them to the side? Thanks in advance for your help! You should be able to drag the field buttons from the page area to the column area. What happens when you try to move them? Jeff M wrote: > I have a pivot table chart with several field buttons across the top. How can > I move them to the side? > > Thanks in advance for your help! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html ...

about inserting data
hi, i am new to this newsgroup. I have little knwldge in Excel. How to create tables in Excel file. and also i want to execute the quries. How can i do that. thanks, regards, koti ...

Manipulating totals and columns in Pivot Tables
Hi, I'm constructing a pivot table that has investors as columns, investments as rows, and the general data is values. Trouble is there is a column which I want to only display half of each value. I know that I can make a formula that divides a column "column A/2", and then hide the unwanted columns. But I would also like the hidden columns to not be included in the grand totals. How do I make this happen? Thanks! Hi, So let me understand what you want, something like this in the Pivot Table: A B C Name Jp ...

Need help with data validation format
I'm trying to make this format mandatory when someone enters his/her data in a cell. The format would be this : "### ###". Therefor, if the worksheet user doesn't enter a chain like this one : "113 244", the data just won't enter. And yes, the space beetween the 3 first and last numbers has to be there. I can't seem to find anything in the Data / Validation menu that enables me to do this :confused:. Any help would be much appreciated. Thanks in advance. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~...

searching data
Is there a way in Excel to search multiple worksheets to collect "hits" of a particular entry? I have a 5-sheet workbook with about 2000 customer names, and I want to see if I have duplicates or repeats over all 5 sheets. >-----Original Message----- >Is there a way in Excel to search multiple worksheets to >collect "hits" of a particular entry? I have a 5-sheet >workbook with about 2000 customer names, and I want to see >if I have duplicates or repeats over all 5 sheets. >. > This feature is available in Excel XP & 2003 -- in the Fin...

export public folder data?
Am in the process of performing an Alternate server recovery of an Exchange 2003 Information Store. The reason being that on the current server all the email has dissappeared from the public folder mail folders...its a very strange situation indeed. Hoping that by restoring an earlier backup to a different machine we can see if the emails will return. If they do, is there a way I could export the contents of these folders back into the current info store? I gather that Exmerge will only work on Mailboxes and not Public Folders... Many thanks in advance, Neil On Fri, 19 Aug 2005 08:58...

How to select data series to format? (alternative needed)
Is there an alternate way to select a data series to format in an XY Scatter chart? The only way I know of is to move the cursor close to the series line and right-click. But if the chart includes many data series and the lines are close together, it is difficult, if not "impossible", to select the desired line. I am looking for a method that presents me with a list of all the data series, and I select the one I want to "right click" (i.e. open the menu that include format, add trendline and clear, among others). Or something else that would not be so difficult to use. ...

Sorting by Date in Pivot Tables
I have a worksheet I would like to make a pivot table from. My problem is that when I do it, the months and years don't appear in calendar order but rather alphabetical order (i.e., April comes first, January is further down). How can I format this to have the pivot table show January of 2002, rest of 2002 and then start January 2003? Julia, If you entered the dates as string values, then Excel will sort them as strings. If you enter the dates as dates, then Excel will sort by date. Format the cell with January 2002 as Number. If it stays January 2002, then your 'dates' are ac...

Pivot Table Grand Total Issue
Hi I have WinXP with Excel 2003 I have a pivot table that has a number of calculated fields in it. One of the calculated fields looks at a column of data that has an amout in it and this is multiplied by another field that has a dollar figure in it. Each line of data the Pivot Table calculates as normal. The problem I have is that the Grand Total works correctly for all the columns in the Pivot Table except for the ones that contain the dollar figures from the calculated field. The Grand Total line display a dollar figure that is approximately 10 times as much as what it should be. W...

Data Not Displaying
I am having a weird instance with my report not showing a couple of data. This report is based on a table and has 7 groups. The weird instance is on group 1, where some of the data appeared but not all. For example, here are my data : ColA ColB ColC ColD .... So far, I have detected that in ColC, the data does not show in all rows. Ex.: I have 13 rows all together, but in rows 3 and 6, Col C is blank. I checked the data in the table and they're all there. It is just not showing up on the report. I checked the Conditional Formating for this textbox, but there i...

Pivot table returns "Problems obtainig data"
Office 2000 Prof. SR_1 with SP4. Created a Form in Access to display data from one "My table" using the Form "Excel Pivot Table". Exported "My table" and this Form to others databases. Works OK in all computers. In one computer is giving the following error message when trying to REFRESH de data: EXCEL Problems Obtainig data. Even when I tried to create it a new Form in that database using the same imported table, gives the same error message. ...