I've checked the text file and it is 46kb and proper one is 90kb but after taking out rubbish it is 4k so I think I will just clean each row and then merge it.
That should work for me.
Thanks for the respone.
Regards
Emil
IT Couple
Last Activity: Nov 3 '09, 04:03 PM
Joined: May 15 '09
Location: UK - Bristol
-
Hi Ck
That sounds like a way to go.
Quick question. In the past I come across an issue where I was exceeded row size but I was getting error and now I don't. Another thing I noticed is that when I use a cursor to merger the rows before I insert them I used print and it printed everything on my screen but it seems doesn't insert it.... Is it possible that it inserts it but cannot display it?
Many thanks...Leave a comment:
-
Hi
I have decided to do it using a cursor which should work fine but i have a problem to insert (insert into) a row with more then 43679 characters. It works perfectly with nvarchar(max) <= 43679 characters but it inserts NULL if it is above it.
That might be also the reason why the SSIS import text file is split into multiple lines.
The table field is text (I tried nvarchar(max)) and the variable...Leave a comment:
-
Thanks for replies.
I will just confirm with the client what exactly he needs and try it.
BDW in 2007 there is no user-level security. Do you what new features replaced it if any?
Regards
EmilLeave a comment:
-
Access 2003 Back End User Level Security
Hi
I had a database with FE and BE where I used user-level secuirty wizard on FE and it works great but I want to secure BE as well. (currently I can simply open it)
Can I re-use the security file mdw or do I have to create new one?
Many thanks
Emil -
SSIS import full text from html or combine rows
Hi
I'm pretty new to SSIS and I wonder if you could help me.
I download HTML files (thounsands) as text files using SSIS and then using foreach loop I load each file into table text data type field. Works great apart from that some files appear on multiple rows I presume SSIS thinks there is a new record but there isn't as I want to load the whole file into the table text data type field.
So I have two... -
Thanks FishVal that is excellent.
I must admit I have studied in the past but didn't get the use of it until now when I needed it :)
Thanks for your help.Leave a comment:
-
Parameter as a list
Hi
If I type in VB msgbox "prompt", at this point I have a list of available options vbAbortRetryIgn ore... vbApplicationMo dal... and so on
Is there a way to create a sub routine with similar parameter which appear as a list. I want my partner to be able to use the procedure and select Edit, Add, Delete from a list instead of typing it (to avoid confusion).
Many thanks in advanced.
Emi... -
Hi I have seen your post and in my opinion people will rather not do it for you. If you want the work done not just answers to your questions I would suggest www.guru.com or www.elance.com
This is only my opinion... I hope you will find the best way to do it yourself.
Regards
Emil -
Hi
1) Do you enter the range in the text box manually?
2) Could you clarify what you would like to do with it exactly (unit table / unit field)
3) If you want to get all numbers in the range and you have 2 input values from / to then I would build a table with all numbers (0 to max possible) and use criteria from / to to get the range I need and then use it for my purpose.
I will try to help more if I get...Leave a comment:
-
SQL Server 2008 SP1 not for XP?
Hi
1) Question one
I'm installing SQL Server 2008 Enterprise Edition on Windowds XP (remotely) and in the 'readme' file it tells me to install SP1 first and then SQL Server 2008 but when I try to download the SP1 http://www.microsoft.c om/downloads/details.aspx?Fa milyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&di splaylang=en
it says Supported Operating Systems: Windows 7; Windows Server 2003; Windows Server 2008;... -
VB/IE how to execute save as or download from HTTPS
Hi
I want to donwload a file from a web (HTTPS) so I log in, right click the link and select save as specify path/filename and save.
I want to do the same use using VBA
Set IE = CreateObject("I nternetExplorer .Application")
or at least after I log in specify the full path which I have and save as
-- Currently I get a pop up with open, save, cancel option
IE.navigate sURL... -
Hi ADezii
Thanks for this I will have a go. Creating external HTML files doesn't seem ideal but I will check this control to see if I can pass the data from a record (and if neeeded use a function to add <HTML> ... </HTML> I hope there is a way to use data from a record directly.
Many thanks
EmilLeave a comment:
-
Store data with HTML tags and display on a report
Hi
In the past I have used HTML tags to generate HTML emails, now I want to store the data with HTML tags but display the data on a report.
Is there a control that is able to undestand HTML tags and apply proper formatting.
This will be simple bold, Italic, Underline
Many thanks in advance.
Emil -
Excel Import Web Page with Javascript
Hi
I want to import data from a website into excel (or database) and currently I do it using ID but it takes about 1minutes to get 100 records and the website ommits some IDs so it seems it is generating more IDs then I can download.
The best solution would be to filter data on web page and download all results but the website uses javascript to go to another page which so far I couldn't make it work with excel. I've... -
Thanks for the link.
What I'm looking for is rather 'general experience'. I would imagine vb.net or asp.net are usually very good solutions so I'm trying to find out if there is a good reason to use or not to use, nothing specific ;)
Regards
EmilLeave a comment:
-
Hi
I'm not sure if the instructions will make sense but.
for the checks box use after_update event and change for instance this property me.Form.AllowEd its = False
Regarding changing the background you have to add a loop into the code
something like that
dim ctr as control
for each ctr in me.Form.Control s
if left(ctr.name,3 ) = "txt" then 'assuming all your text boxes start with...Leave a comment:
-
Hi
You should be able to join all 3 tables and use WHERE for all conditions. Is that not working for you? (Subqueries are an alternative)
I hope it helps
EmilLeave a comment:
-
Access 2007 Developer Extension
Hi
I've heard that I can convert Access database into normal stand alone program using Developer Extension.
What are the limitations or incompatibiliti es or difficulties that I can expect when using it?
My first quesiton would be how do I update it so the user doesn't lose the data?
Many thanks in advance
Emil -
Thanks for the information.
It might be a bit too late to use VB6 ;) so I will investigate the subject on .net forum soon.
Regards
EmilLeave a comment:
No activity results to display
Leave a comment: