Importing Date

[gls]

Hi

I have Access 2003 database and trying to import 120,000 rows of data for a properties table from Excel. The Excel book has 4 sheets and I need to import all the data from the 4 sheets into the one table. Access will not allow me to do this. Can anyone suggest a way around this?

Thankyou

Garry

 

[John Big Booty]

As you are importing Excel worksheets I doubt that the data is Normalised. Read up on normalisation, once you have a grasp of that, you should be able to work out a scheme for importing the data in stages, rather than trying to do it in one hit.

 

[gls]

Yeah I understand the normalisation and mentioned that Access will not allow me to import the data in stages, which is what I wanted to do to solve the problem.

 

[John Big Booty]

I don't understand why access would not allow you to import this data in stages. How does Access know that you intend to do this Your assertion that;

....and mentioned that Access will not allow me to import the data in stages....

Is not supported by anything you have written in your OP.


The fact that you are trying to put four Excel work sheets into one table leads me to believe that this statement is not entirely accurate;

Yeah I understand the normalisation ......

 

[John Big Booty]

As you are importing Excel worksheets I doubt that the data is Normalised. Read up on normalisation, once you have a grasp of that, you should be able to work out a scheme for importing the data in stages, rather than trying to do it in one hit.

What I was trying to say in this post (possibly non too clearly) was that you will need to look at importing your data into a number of normalised tables, and that to achieve this will require a number of steps.