PDA

View Full Version : importing data from SQL Server via data connection



muzac
2013-03-01, 08:04 PM
I am using an inherited spreadsheet that has some query connections already set up. I am trying to add a new one but when I do the data is automatically imported into a table. Not a big deal except that if I try to share the file I get an error because it includes a table. Is there a way to set up and use a connection such that the data is imported to a cell range and not a table. Also, after import into the table if I try to convert to range that break (and deletes) the database connection. Seems so basic but I am stumped. The file has to be shared. Any ideas? Thanks for your help.