Viewing 15 posts - 16 through 30 (of 37 total)
The Name field in the SQL Table is varchar, I've checked the data within the database and the names look fine.
February 25, 2014 at 7:29 am
Text Qualifier is " and Column Delimiter is Comma [,]
The code page for the export is 1252 (ANSI - Latin I) and the field data types are all set to...
February 20, 2014 at 4:16 am
Thanks for that, i've tested the code and it works fine.
Thank you to everyone for their help.
October 26, 2011 at 6:38 am
This is the from clause for the query:
FROM [Transaction] Payments
INNER JOIN Debt ON Debt.DebtCode = Payments.TransactionDebtCode
IF @JointDebtor = 'Yes'
(INNER JOIN DebtDebtor ON DebtDebtor.DebtCode=Debt.DebtCode AND DebtDebtor.DebtorLinkId=ISNULL(TransactionDebtorLinkId,(SELECT MIN(DebtDebtorID) FROM DebtDebtor AS MinDebtorCode...
October 26, 2011 at 5:32 am
Just re-read my post, the example did not quite show how the joins are written. Please see below:
(Case When @parameter = 'Yes' THEN
INNER JOIN Table2 ON Table2.DebtCode=Table1.DebtCode AND Table2.DebtorLinkId=ISNULL(TransactionDebtorLinkId,(SELECT MIN(DebtDebtorID)...
October 26, 2011 at 4:49 am
Hi Guys,
Thank you for your responses, apaologies for the delay in getting back to you, i have been away for a week or so and haven't had chance to log...
July 5, 2011 at 6:15 am
This is the line where the error is occuring
Set rstFilePath = CurrentDb.OpenRecordset("Source_File_Path")
June 29, 2011 at 7:55 am
Hi Joeseph,
I have tried the statement with ISNOTHING and it is still pulling up the same error, might have to give this up as a bad job and re-visit the...
May 24, 2011 at 5:28 am
Hi Charles,
Thanks for the response, unfortunately i've tried that and still got the same error, all i'm getting is #error where the figure should be in the report.
May 17, 2011 at 9:32 am
That worked perfectly, thanks for everyones replies.
February 10, 2011 at 8:04 am
When i uploaded my reply it removed the spaces in front of the numbers in my example. Please see below new example with * for spaces.
*****1000.00
******100.00
*******10.00
********1.00
Thanks
February 10, 2011 at 7:46 am
Hi John,
The padding is exactly what i want to do, the report needs to look like the below.
1000.00
100.00
...
February 10, 2011 at 7:44 am
Hi John,
Apologies for not being clear, the date is in the column beofre the decimal. I have been asked to create a file that goes into a fixed width import...
February 10, 2011 at 6:35 am
Tell me about it, i'm hoping that somewhere along the line wires have got crossed and the file does actually need the commas in the header. Thanks for the responses,...
February 1, 2011 at 8:14 am
Viewing 15 posts - 16 through 30 (of 37 total)