 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008Exclude a column from data import
Hi there, I am using Excel 2003 and am importing live data into a sheet. Everytime the page loads the current data is pulled in from an SQL 2000 view. The person who wants to use this spreadsheet wants to put an extra column in the middle of the data. I have created a null column in the view so that it is blank, but when you insert something into the column and and refresh occurs, the column quite rightly gets overwritten with null. Is there a way to remove the data from just one column? I understand (I think) that if the order changes, or if a row is deleted from the table, the manually inserted data will be out of sync. Cheers, Steve hi how are you importing the data??? if you are using microsoft query...not going to happpen. sorry. if MSQ, the data being imported is a imported as a named range c (check insert>name>define...) and all areas inside that range is reserved for the MSQ. you can line formulas up to the left, right and bottom of the MSQ but that's it. adding columns or rows to the center of the MSQ just screws things up. if your are importing another way. post back. regards FSt1 > Hi there, > I am using Excel 2003 and am importing live data into a sheet. Everytime [quoted text clipped - 12 lines] > > Steve > hi > how are you importing the data??? [quoted text clipped - 5 lines] > up. > if your are importing another way. post back. It is with MS Query, from a view in SQL 2000. Is there another way I could get the data? Steve What I would do is to use macros to copy the data over to another sheet, in the format I wanted.....4 columns, empty columnn, more columns etc and do my work on that sheet...........when new data comes in, re-copy it with the macro so things will go where you want them to............ Vaya con Dios, Chuck, CABGx3 > Hi there, > I am using Excel 2003 and am importing live data into a sheet. Everytime [quoted text clipped - 12 lines] > > Steve |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.