Martin Reid
mwp.reid at qub.ac.uk
Fri May 4 03:26:48 CDT 2012
Andy Excel 2010 Server Name Login: Need to work out how you want to authorise the user. Using a default user for all data or authenticate each individual user. There a ribbon option to do this in Excel which will create the connect for you. Install SQL Express and connect and play about. Martin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: 04 May 2012 09:08 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Excel and SQL Server Thanks for the pointer Darryl. Is anyone able to answer my specific questions? Andy -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: 04 May 2012 01:33 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Excel and SQL Server Also if you have XL2007+ have a look at the free power pivot addin. Useful for doing exactly what you are considering. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Friday, 4 May 2012 2:46 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Excel and SQL Server Hi folks, long time no ask This is a bit OT and will seem a trivial question to many so I crave your forbearance (sorry but we're having wall-to-wall Shakespeare over here to tie-in with the Olympics and we all have to speak Elizabethan during daylight hours, forsooth). I've been asked to look at setting up Excel sheets to read a SQL Server database. Not rocket science but it's an age since I did anything like this before, so I've a couple of questions. 1. What info do I need to make a connection - name of server, name of database, password, names of tables? that it? 2. Are there better and worse ways of creating the connection in Excel? If so, what are the better ones and those to avoid? 3. How do I practise? Can I get them to send me the db as a file or files? What form does it (or they) take? I guess I'd then need to install SQL Server Compact (or is it Express) Edition so as to be able to read it, would I. Do both (Compact and Express) exist and if so what's the difference? Any clarification/suggestions very welcome. Cheers Andy -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com