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

How do I Convert excel data into access

P: 1
I have an excel sheet. its format is like a group eport in access example given below:

Soap
Sr. no. Qty. Amount
1 15 150
2 10 1000
3 5 5000

next page
Soap
Sr. no. Qty. Amount
4 15 150
5 10 1000
6 5 5000

next page
Soap
Sr. no. Qty. Amount
7 15 150
8 10 1000
9 5 5000

next page
Shampoo
Sr. no. Qty. Amount
10 15 150
11 10 1000
12 5 5000

next page
Shampoo
Sr. no. Qty. Amount
13 15 150
14 10 1000
15 5 5000

next page
Hand wash
Sr. no. Qty. Amount
16 15 150
17 10 1000
18 5 5000

Any who help me how can I convert this data into access from excel sheet quickly. I am fresher about programming and excel and access also.

I will thankful you always in future.

Yogesh bhardwaj
Mar 12 '08 #1
Share this Question
Share on Google+
1 Reply


Expert Mod 2.5K+
P: 2,545
Hi Yogesh. The Excel sheet you mention is not easily convertible into a standard tabular format. This is because it has a repeating vertical structure of
Expand|Select|Wrap|Line Numbers
  1. Heading
  2. Data
  3. Footer
  4.  
  5. Heading
  6. Data
  7. Footer
which cannot be translated into a format suitable for entry into a table by any native Access facility.

Whilst it is possible to develop VB code which could do some form of conversion it is a non-trivial task, and is one that is dependent on knowing for certain the regularity and structure of the Heading/Data/Footer contents.

I think this lies outside of the range of questions we can actually assist you with. Sorry.

-Stewart
Mar 16 '08 #2

Post your reply

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