Question Excel to Access

[daveee143]

Guys could you help me.....

1. how to transform excel data to access

2. how to create run time application : i tried it to make accde but no luck T_T "

 

[John Big Booty]

Guys could you help me.....

1. how to transform excel data to access

...

First you will need to normalise your data, you might find working through a tutorial helps to to come to grips with that subject. You may also gain some inspiration for your table structure amongst these data models.

...

2. how to create run time application : i tried it to make accde but no luck T_T "

This article pertains to Access '03 which required the developers extension, which had to be purchased, since then you require the free developers extension, do a Google search on the subject pertinent to the version of Access you are using.

 

[daveee143]

Thanks a alot Sir John

 

[daveee143]

Sir another question is that possible i used the crystal report to link my excel to my access?

 

[John Big Booty]

Sir another question is that possible i used the crystal report to link my excel to my access?

Sorry I have no knowledge of crystal report