Access importing of data.

Resolved · Low Priority · Version Standard

Shelley has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

by - delegate Shelley [4 posts] (2008 Feb 20 Wed, 11:39) Reply

This there a limit on the amount of records you can import from excel into access?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu + 9 Fri	Southwark	4	book now	£475	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	6	book now	£450	£485
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
2003	2009 Jun 4 Thu + 5 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 11 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Access importing of data.

by - trainer Pete platinum contributer [816 posts] (2008 Feb 23 Sat, 09:43) Reply

Hi Shelley, Thank you for your post, in answer to your question Access 2003 has limits but they should easily accommodate your Excel spreadsheet, the maximums are as follows:

Database file size: 2 GB less the space required for system objects.

Number of fields in a table: 255

Maximum table size: 2 GB less the space needed for the system objects,

Number of characters in a Text field: 255

Number of characters in a Memo field: 65,535

Number of characters in a record (fields): 2000 (excuding Memo and OLE objects.

Number of characters in a cell in the query design grid: 1024

Number of caracters in a text box in a form or report: 65,535

Number of nested levels: 7

I hope that helps, best regards Pete