Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing
Sandra has attended:
Access Introduction course
Is there a limit on the amount of data you can pull through from excel to Access?
Hi Sandra, thanks for your query. Access can hold up to 2GB of data. After that, it's time to split the database!
Hope this helps,
Anthony
Tue 8 Feb 2011: Automatically marked as resolved.
Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.
- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.
- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.
- Use the Currency data type for monetary amounts.
- Use Date/Time for dates.
- Most other numbers can use the Number data type, but the Field Size property may have to be altered.
- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
