well I had
Code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblGWOSData1", "C:\worklist.xls", True
Code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblGWOSData1", varFile, True
Keredw
Last Activity: Sep 17 '13, 05:52 AM
Joined: Aug 31 '13
Location:
-
OK its embarrassment time again..... Remember that one line of code "What can go wrong?"...
well I had
which I must have done during the developement phase when I should have had...
In... -
For information and completeness, I have abandoned the Transferspreads heet method of bringing the table into Access. After sending out 66 reports on Friday one of my colleques pointed out that there was a wrong date in one of the 4,000 records. The SAP file was good. The exported Excel file was good. The manually imported file was good but the Transferspreads heet method put the wrong date in this particular record (was 12/8/2013 but became 17/6/2013)...Leave a comment:
-
Thank you again for taking the time to reply with such a comprehensive answer. Unfortunately I am using software at work and I wish to have it work for others so I need the solution that is transparent to the user. We will migrate to 2007 in the future but it is 2003 for now. I have Office 2013 at home.
Thanks again.Leave a comment:
-
Thank you for your reply. There is nothing special about the code, it is just the standard one line code using the TransferSpreads heet method. I have actually found others with a similar problem but in reverse. They had a Hash in the Excel Header name and the import converted it to a period?? What I have done as a work around is to run a VBA Delete query to empty table1 and table2. Use the Transferspreads heet to import data (with hash in column...Leave a comment:
-
Importing Excel with full stops in column heading
Software we use produces an Excel spreadsheet that is manually imported into Access 2003. Up until now this was OK. I then employed the TransferSpreads heet method to automate the process. Some of the column headings now has a hash, so instead of being [End Dt] it was now [End Dt#] which didn't please the queries at all. Found that some headings had full stops in them (Periods) so [End Dt.] was [End Dt] if imported manually but [End Dt#] if the... -
After much Googling and head scratching, I found the answer and as I suspected, it was VERY simple.
Add the OpenArgs to the end of the doCmd.OpenRepor t and then in the report, set the Control Source for the Text Box in the Report Header to be =[OpenArgs].
Can I acknowledge the source of...Code:Name1 = sContactName DoCmd.OpenReport "OpReport", acViewPreview, "", name3, acNormal, Name1
Leave a comment:
-
No Need to reply. I am reading your terms of use section. It has all the info I need.Leave a comment:
-
Sorry. By the way, what are code tags and how do I use them??Leave a comment:
-
Putting variable (Looping) into Report
Using Access 2003
I am looping through table values and creating a separate report for each name. The report is then emailed with a TO: and CC: address. That works fine. What I would like to do is put that value (someone's name) in the header of the report. The field containing the name can have up to 5 names in it. I use the LIKE filter to determine if the name is present. The only time the unique name exists is in the loop as it cycles...
No activity results to display
Leave a comment: