Let me see if I can further explain. The spreadsheet in question has as stated below the first four columns; dept, description, source(where the information will be coming from) and then the rest of the columns will be the information for each of these departments for each day. Each column will have the date at the tope and statistic for that department on that day.
I will then need to be able to grab statistic for the specific department and for a specific day. They are trying to link to the spreadsheet so that as the new day's data is updated it will be available for the database.
Everyday I will need to know how many people are in a specific department to see if they have enough coverage for those patients.
I know I can link the spreadsheet but I am afraid that because the data is going accross instead of down I will have trouble making a robust process.
--- In AccessDevelopers@yahoogroups.com, "Hoffman, Tobi K (DYS)" <Tobi.K.Hoffman@...> wrote:
>
> It has likewise been some time since I have imported Excel data (have just revisited doing exports to Excel), but there is one thing I remember from several years ago. If you have columns in the spreadsheet where there are 25 rows that have no data, Access will not recognize those columns as dates. I know, because I had to experiment with that; a date in the 25th row was okay, but the 26th row was not! I believe that what I did then was to import the data into an existing table with the columns already defined as date fields.
>
> But maybe that isn't a problem with your data!
>
> Tobi Hoffman
> Dept. of Youth Services
> Boston, MA
>
> ________________________________
> From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of Toby Bierly
> Sent: Wednesday, September 14, 2011 3:12 PM
> To: AccessDevelopers@yahoogroups.com
> Subject: RE: [AccessDevelopers] Importing Excel Data
>
>
> Without seeing the spreadsheet, all I can say is yes you can import it (if you run into any problems with it not liking any special characters in the dates that are the column headers, you could possibly need to change the format of the column names), and in Access it will be the same with dates at the field names after those first four fields/columns.
>
> Whether that will work for what you want to do or not, I'm not sure until I know what you need to do with the data..
>
> Hope that helps,
> Toby
>
> -----Original Message-----
> From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of m_bacheldor
> Sent: Wednesday, September 14, 2011 12:02 PM
> To: AccessDevelopers@yahoogroups.com
> Subject: [AccessDevelopers] Importing Excel Data
>
>
> Good Afternoon,
>
> It has been a while since I have had to deal with this so I am claiming that I am rusty, and not old and forgetful. I have an excel spreadsheet that I need to import into Access. My problem is that the data is set up with the first four columns contain the followinf headings;
> Dept Description Source and then the rest of the columns are dates.
>
> I will need to import or link to this data based on the date, but I am not sure if it will work with the column headings being the date.
>
> I am hoping that I am making a mountain out of a mole hill so I look forward to your responses.
>
> Mark
>
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar