ms access courses - importing

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » ms access courses - Importing

ms access courses - Importing

resolvedResolved · Low Priority · Version Standard

Melissa has attended:
Access Introduction course

Importing

What are the maximum amount of data lines that can be exported into Access?

RE: Importing

Melissa

It is pretty big. Depending on the version that you are using, a table cannot have a total file size bigger than 1 gigabyte. This means that the number of records is flexible, depending on how much informtion you have in your records.

Remember that each caracter is 1 byte
1kb = 1000bytes
1mb = 1,000,000
1gb=1,000,000,000 bytes

Regards

Richard

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips


Server loaded in 0.08 secs.