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
From:
Sent: Wednesday, September 14, 2011 3:12 PM
To:
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