xp_cmdshell may not be getting the same "path" as a user account.  Try giving the FULL path to the command and see if that works.

Doug,

I'd almost bet that your MARGINS are causing the problem.  Make them as wide as you can (like 0.25 left and right) and see if your problem goes away.

May I suggest that instead of exporting SQL data to MS-Access, you just create an MS-Access database and either Link the necessary tables (with links), or create Views in SQL...

I too detest SPACES in ANY names, Directory, Files, Tables, Fields, etc.  I have noticed that when using MS Access that IF there's a space in a field name, Access...

Sorry, all, but me thinks that some of you

are making this much too hard.

-- Create this function

-- It will return ALL colors for each item

-- Change sizes to more appropriate...

OR on the assumption that your new daily data file has all the updates and inserts:

Use a DTS package to Truncate yourTable

Then

Import the New/Revised Data

This can be done in one...

I too would like to see comments in English (or multiple languages) simply to make it easier to follow the script.  Code is code is code - we can all...

Looks to me like the problem might be with your Inner Join:

FROM Table t

Inner Join Table1 t1

On

   T.HIDDateTime = T1.HIDDateTime

WHERE (T.HIDDateTime BETWEEN @FromDate_LU AND @ToDate_LU)

This might work...

Well, darn, I answered this and when I hit Post Reply the system threw it all out! 

Anyway, to try to answer your question...

IF the structure of your table does not change from one load to the next, it might be easier and faster to TRUNCATE table tablename then do the import.

If you're presenting the results of this query on the web, you might need to use a align="right" tag and this will format the number to TWO decimal places:

<%=FormatNumber(rs("BD_TR_AMT"),2,-1)%>

Hope this...

Try char(13)+char(10)

I had trouble trying to concatenate things in a MS Access query where CRLF pairs were needed.  I first tried using char(10)+char(13) (LFCR) and absolutely NOT getting what I...

I have NO idea... have you tried a "compact and repair" on that database to see if that might make some difference?

You didn't indicate HOW MUCH data you're going to transfer each time, but I have several setups using MS Access as a front end for some of the departments where...

Since you'll be importing data from MS Excel, be cautious about checking to see IF you need to TRIM the Excel data for spaces.  Also, I had where one of...