I'd like to read a huge comma delimited text file (> 1 million lines of data) into Access via VBA. The .txt file looks like this:
1,4850,70515.8,97000
2,4850,70515.8,97000
3,4850,70515.8...
i would like to compair sheet1 columnB to sheet2 columnB, if they match i want to copy the number in column D into a new sheet while retaining the first 3 columns, so sheet3,a = sheet1,a ...
I set up Entourage w/Exchange on the laptop and it worked fine. Now I am trying to set up the same account on the Mac Desktop and it keeps giving me this error. I have the same settings as on ...
I installed act!2007 with success and converted my act!2006 databases with out incident. I even am able to synchronize with our other computer with success.
HOWEVER -- I can NOT create a NEW...
Hello,
I'm developing in Dreamweaver and have a question about layers. Why is it that layers align differently depending on what size monitor you are working on? For instance, when I deve...
This is not a big deal, obviously, but where do you set the default toolbars to show in the taskbar? Somehow the "Language bar" is always showing when I boot up and I have to manually turn it...
I have a table in Access with 2 fields, 1 field has 10 possible decimal numbers and the second field has it's corresponding fraction text.
A second table has several fields populated via a...
Microsoft Outlook, 2003: My outlook will not send or receive emails, I continue to get the error:
Task 'mail.harlequinna.com - Sending' reported error (0x800CCC0F) : 'The connection to the s...
I used to use AT to open an instance of cmd.exe and launch regedit for forensics work. Later, I used cmdasuser utility to do the same. With Vista is there a method provided to do the same acti...
Windows server 2003 and XP machine
We created an OU and applied a group policy to it. For some strange reason when I do a gpresult on one of the computers in the OU the computer settings sho...
Hellow Experts,
I am having some problem designing my header control panel with div.
What I am doing right now is I have taken one main div.
In that main div I want to put 3 div with some...
Can anyone confirm that Linux File System ext3 has no real archive bit setting on files like Microsoft's
attrib A for archived ready to backed up state. You would think a permisions bit cou...
Hey all,
I've got a 2003 Microsoft access project (ADP) tied to a SQL Server 05 Express backend db (using ADO). I am getting pretty close to a deadline for finishing a project and I haven't r...
Hi experts
I'm running windows XP on my desktop and laptop connect by wires to an Edimax router.
Last week I suddenly lost my network connections.
On the desktop i have 2 XP Operating sys...
Does anyone have any experience with SQL 7.0 (or other product) extended support? Specifically - approximately how much does it cost? I am planning on taking SQL 2000 beyond 4/8/2008 into th...
I installed PHP5 on a windows 2003 machine. I made the manual installation as the msi installer did not work.
First I recieved an CGI Error on all php files, then I use the manual from http...
Are my Laptop P4 3.0 Ghz CPU Temperatures too High.
We are dealing with a IBM G40 Laptop that had a new motherboard installed by a non-professional. I may have done a fine job of installing...
Brand new Sony Vaio SZ450 series with Windows Vista Business. Explorer crashes any time I try to perform a simple drag and drop operation, like dragging a folder into another folder. This is a...
I've just bought a DVD writer and I'm having problems with burning DVDs.
I got Nero 7 Essentials software supplied with my DVD writer and when I try to burn anything onto DVD, Nero takes 2 ...
when u deploy ur portal project in RAD 6.0
there are 2 choices
1) websphere portal 5.1
and
2) websphere portal 5.1 stub
what does the "stub" means ?
Hi everyone
I find that I often have to tell Windows to view hidden files, and then a few minutes later to hide them again. I know how to do so:
Windows Settings- Folder Options Vie...
I have a menu at the top of my page which is three buttons (links) horizontally on a row just under the header at 100% page width.
They are contained in a table, set to 100%, with three td'...
I'm trying to setup a webbase helpdesk software and after connecting to the database, this is the error i got.
Microsoft VBScript runtime error '800a0046'
Permission denied
/readyde...
I want to run terminal services over the internet and do it without a vpn connection to cut down on the overhead. I'm concerned about security and have been doing research about TS security. I...
We had a HP Proliant G3 Server 2000 OS server crashed. We built a new 2003 OS HP PROLIANT G4, but cannot get it to recognize the 4 existing data disks from the 2000 machine. it only recogniz...
