Exporting a Million+ records into Access?

[rsmonkey]

First of all, can I export this amount of data into a single access table?

Secondly this information is stored within an Excel Spreadsheet at the mo but, in a limited form. Baisically there is a count field for values that are identical. So what I have got is a list of software owned by the company and license entitlements i.e how many machines the company has paid to cover.

Information looks abit like this:

Adobe | Acrobat | Professional| 7.0 | 20,000

What I need to happen is when I import the file into access I need it so that I have 20,000 entries into my table of Adobe | Acrobat | Professional | 7.0 |
So my second question is what is the best way to acieve this?

Anyhelp will be much appreciated!

cheers

 

[PeterF]

The only limit you have is the size of the database (max 2Gb for AC2000) so I don't see any problem there.
Default Import from Excel in Access will look for the data type in the first row (or the second if the first is column headers).
If your sample info is correct I don't see the point in making multiple entry's for the same application as you don't seem to have a field for where it's installed if there's one then for future mutations I would split the info across following tables.

tblSoftwareDescription (Autonumber PK and fields for the SW description and # of licenses)

tblComputerdescription (Autonumber PK and fields for the description of the hardware)

tblSoftwareInstalledOn (FK to SoftwareDescription and Computerdescription)

This way you can see where things are installed and can keep better track on the amount needed.

 

[rsmonkey]

Hey,
Cheers for the reply! Baisically i been asked to making a content management system to handle a companies software/licensing/hardware assets and this database has gotta log 200000+ pc's, 10000+ diff bits of software and a mamoth amount of licenses! The format in which i have been given the information is rubbish and very inconsistent which only makes things harder.. they want licenses to be directly assigned to hardware and i was simply being lazy i just wanted to make a module that would import the information, then it would make it alot less work but i understand that that method is bad in all aspects e.g. design, normalisation etc etc... now you made me feel bad Peter im gonna have to do it properly! damn you man...