If the SQL table has an Identity field then you can import the autonumber field into it by selecting the 'Enable Identity Insert' on the Options tab of the datapump.

If the field structure is the same for each table, then you could try this.

In the datapump source, you could try using an SQL query instead of just selecting the sheet...

Do you need this for some sort of paging functionality, or something? There are plenty of examples around that illustrate paging through resultsets.

As per Books Online, the RTRIM  function "Returns a character string after truncating all trailing blanks" therefore it's totally different functionality to ROUND and CONVERT.

Well at least it works, but it doesn't really solve your initial problem. The only difference between this

MyString = MyDate.ToString("hh:mm");

and you snippet of code, is that you're refrencing a...

Are you sure "Fields!job_date.Value" is being read in your application as a datetime?

Would it be possible for you to provide the error message ?

Might be a little helpful in determining what the problem is

Scott

Depending on how the Access database connects to the SQL Server data, you could find that all the data gets pulled down to the client machine for sorting and filtering...

Take a look at the series of posts I'm putting together on my blog about a very similar technique.

We use Robocopy as part of our log shipping from our production site in Melbourne to the DR site in Sydney. It is also used to copy backup files to...

Are you talking about copying the file via WAN/Internet?

Windows Resource kit has a tool called ROBOCOPY that can be used to copy the files. One of the many switches for...

Moe

To avoid any confusion,and allow people to help you in the right direction, is it possible for you to write/type out exactly what your expected output should look like. Once...

SQL doesn't track of changes made when you use ALTER PROC. All that happens is the text of the stored procedure is replaced in syscomments.

To find out when it changed you'd...

You'll need to specify a format file to have less columns. Check the BULK INSERT command in Books Online for details.

As I mentioned in my earlier post, I have a sneaky suspicion that its the hyphen in the servername. Although I can't find anything that proves, or disproves that. On...