importing data from SQL Server via data connection

muzac

New member
Joined
Mar 1, 2013
Messages
1
Reaction score
0
Points
0
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.
 
Back
Top