Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

sql data and manual

Forum home » Delegate support and help forum » Microsoft Excel Training and help » SQL data and manual data

SQL data and manual data

ResolvedVersion 2007

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

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?



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

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 courses

98.7 % recommend us

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

See also:
Hints and tips
Forum topics

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Please browse our web site to find out more about
advanced excel seminar training and other training courses.

Excel tip:

Converting an American date format to European using Formula

Excel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following.

1. Extract the date components mmm dd yyyy, by using the the Text functions LEFT, MID or RIGHT

2. Reorder dd mmm component and concatenate using "&" in the right order this will create a text string with the date in the right order it then needss to be converted to a value so excel can recognise it.

3. To convert to value encase in TEXT function.

4. Format to desired date format.

View all Excel hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.1 secs.