How do I Convert excel data into access

[yogeshbhardwaj]

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

[Stewart Ross]

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

Heading
Data
Footer
 
Heading
Data
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