By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,234 Members | 1,823 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,234 IT Pros & Developers. It's quick & easy.

Import specific row/column from Excel to Access

P: 9
Dear All,

I'm trying to import daily data from other department to my access file. The thing is their data aren't in columnar order and I need almost all the data they've provided which is scattered in different specific row and column.(Please check the attachment for the sample file)

Is there any way for me to import their original format data to my access table without changing their format?

Since the data is daily, then there's a big opportunity for me or my colleague can import them twice by mistake, please let me know how to prevent it.

Thanks in advance
Regards.
Attached Files
File Type: xlsx DailyAnalysisSample.xlsx (11.8 KB, 481 views)
Jul 22 '12 #1
Share this Question
Share on Google+
2 Replies


zmbd
Expert Mod 5K+
P: 5,397
Please read this thread... post #4
http://bytes.com/topic/access/answer...te-access-info

You should also make note of the fact that you will have to provide ways to double check the data types etc... this is also discussed in the above thread.


The transfer worksheet method will work.
Sorry if sounds short - not at my normal PC's :)
Jul 22 '12 #2

NeoPa
Expert Mod 15k+
P: 31,419
Eko, be careful how you ask questions. This is borderline and may well have been deleted as you ask multiple questions as well as basically asking for your work to be done for you. Read the threads about how to, and the scope that's expected, and I'm sure we'll have no more problem threads from you.

-Mod.

PS. We'll leave this in place, but do bear in mind the boundaries as you continue.
Jul 23 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.