98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » SQL data and manual data
SQL data and manual data
Resolved · Medium Priority · Version 2007
Thu 8 Jul 2010, 10:57Delegate Peter said...
Peter has attended:
Excel Advanced course
SQL data and manual data
Hi,
I have a database which is generating an automated spreadsheet.
Inside this sheet I have created a column in which I have entered data manually.
Every time I refresh the data sheet, all of the information on the manual column is moved around to other cells in the column at random. This has left me baffled, I'd assume that the manual data would move in its selected row with the other information either side of it.
Note that when I refresh, its only the manual information jumping, everything is staying as it should.
I hope that makes sense!
Regards,
Peter
Mon 12 Jul 2010, 08:51Trainer Newson said...
RE: SQL data and manual data
Hi Peter sorry for the delay in answering this question.
Peter what I would like to know is how is this new information you've typed in the spreadsheet is represented in the database.
Also although you may be able to open the database using excel do you have rights to modify the database? Could you check with your IT Dept?
Tue 13 Jul 2010, 11:17Delegate Peter said...
RE: SQL data and manual data
Hi Newson,
No worries about the delay.
The new data is entered manually in an inserted column at the end of the worksheet.
I can modify all the data at its source that is being exported by the database, if that is what you are asking?
Peter
Tue 20 Jul 2010, 16:55Trainer Newson said...
RE: SQL data and manual data
Hi Peter
sorry about the delay in getting back to you
I'm a bit foxed by your dilemma can I ask what is the nature of the information that is moving around
Have you tried to export the info to a CSV to see if that replicates the error?
Many thanks
Newson
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Calculate age or serviceThe DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip: |
