Viewing 15 posts - 346 through 360 (of 6,036 total)
If you can send me a file I'll give it a whirl on how I would process it. robert@sterbal.com
The file is posted above:
12345678901234567890,MARCH1
I named it "FaultyImport.csv", but feel free...
_____________
Code for TallyGenerator
It takes less than 10 keystrokes to convert a column to text. (Ctrl + space, alt + 1, alt + C, t, t enter)
I'm getting the impression that you...
_____________
Code for TallyGenerator
The import process is a different type of potatoes.
😎
OOXML and MOX, Open Office XML and Microsoft Open XML file standards are the same. I've tested around 17 different OOXML...
_____________
Code for TallyGenerator
In nearly 30 years of using excel there are very few situations that don't have a straight forward work around.
built a report from an SQL database for...
_____________
Code for TallyGenerator
In nearly 30 years of using excel there are very few situations that don't have a straight forward work around.
built a report from an SQL database for...
_____________
Code for TallyGenerator
The table is over-indexed in multiple desperate attempts to fix performance issues caused by lousy design and bad choice of the clustered index.
When inserting a new row you add records...
_____________
Code for TallyGenerator
In nearly 30 years of using excel there are very few situations that don't have a straight forward work around.
built a report from an SQL database for a big...
_____________
Code for TallyGenerator
It's hard to be specific with an advice without knowing how the procedure is built.
but generally speaking - you can include any value of any variable you're interested in while...
_____________
Code for TallyGenerator
Viewing 15 posts - 346 through 360 (of 6,036 total)