just so I understand you correctly.

At the moment, the system we have has 4GB of RAM that cannot be used?

To make it use more, we need an upgrade to 64-BIT?

Thanks

GermanDBA

Hi SQL_Noob,

As far as I was aware the system can only assign a maximum of 4GB to a single process. The OS can see the full 8GB.

Does this mean...

Hi everyone,

I'm afraid that I have not been able to find a clever answer to the setup of our server by reading what the linked sites say. Hopefully someone...

Hi Matt,

What type of sort is being done on the data if your desired sort is not performed?

Have you tried checking the collation of your Access table? 

You can specify...

Hi,

I have used a similar looping system a few times, and have noticed that it has to do with the way you set your declared variable.

You have told the server...

Hi Paul Mc,

If you are only importing the data once, you can also copy the data from Excel into the clipboard and paste it directly into the target table using...