Get data from Access

%3CLINGO-SUB%20id%3D%22lingo-sub-2128115%22%20slang%3D%22en-US%22%3EGet%20data%20from%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2128115%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20having%20problems%20in%20retrieving%20data%20from%20Access.%20I'm%20establishing%20a%20connection%20between%20Excel%20and%20an%20Access's%20query%20through%20get%20data%2C%20but%20I've%20noticed%20Excel%20only%20retrieve%20the%20first%201600%20records%20and%20not%20all%20the%20records%20coming%20from%20the%20query.%3C%2FP%3E%3CP%3ECan%20someone%20tell%20me%20if%20there%20is%20any%20restriction%20in%20the%20amount%20of%20data%20can%20be%20loaded%20in%20Excel%20through%20Get%20data%3F%20The%20number%20of%20records%20doesn't%20exceed%2046000%20in%20total%20and%20as%20far%20as%20I%20know%20Excel%20should%20handle%20it.%3C%2FP%3E%3CP%3ENot%20sure%20if%20there%20are%20options%20that%20limit%20the%20amount%20of%20data%20that%20Excel%20or%20Access%20can%20share.%3C%2FP%3E%3CP%3EOr%20if%20someone%20could%20suggest%20me%20a%20way%20to%20connect%20to%20an%20Access%20query%20through%20VBA%20and%20loading%20all%20records%20I%20would%20really%20appreciate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20help%20you%20can%20provide%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2128115%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2128722%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20data%20from%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2128722%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EMicrosoft%20Community%20heIpline%20is%20there%20to%20heIp%20with%20you%20issue%20%2C%20talk%20to%20ourLevel%203%20expert%20team%20to%20get%20your%20probIem%20resoIved%20on%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%F0%90%91%91~%20%5B%20888~256-1029%20%5D.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

Hi,

I'm having problems in retrieving data from Access. I'm establishing a connection between Excel and an Access's query through get data, but I've noticed Excel only retrieve the first 1600 records and not all the records coming from the query.

Can someone tell me if there is any restriction in the amount of data can be loaded in Excel through Get data? The number of records doesn't exceed 46000 in total and as far as I know Excel should handle it.

Not sure if there are options that limit the amount of data that Excel or Access can share.

Or if someone could suggest me a way to connect to an Access query through VBA and loading all records I would really appreciate.

 

Thanks for any help you can provide

 

 

1 Reply

@Tom_Walker You are a fraud! Notified the moderator. Please stay away from this Community.