Search results for query: *

I have attempted to format an imported text field to be a fixed length of 9 for some fields that contain spaces. ex: sub-id 56892 000056 78 0000A 123 I thought the Format(Trim([sub-id],"000000000")) was great and have used it sucessfully in the past-or so I thought. The format...

I have been successful in creating an ODBC connection and linking to SAS dat files using MSACCESS2000. When I attempt to link to a sas view, I get the following error. "The Microsoft Jet database engine could not find the following file (SAS View File Name.) Make sure the object file...

I have been successful in creating an ODBC connection and linking to SAS dat files using MSACCESS2000. When I attempt to link to a sas view, I get the following error. "The Microsoft Jet database engine could not find the following file (SAS View File Name.) Make sure the object file...

I am importing a txt file with a field into a table that could be less than the desired 10 character length. I would like the field to import as 10 character with leading zeros if it is less than 10. I want to keep it as a text field instead of numeric. I am able to format the field in a query...

I have just finished a quick macro to automate a daily report. I have read about all the Transfer Spreadsheet horrors and have run into a similar problem. I think I'll have to do a DoCmd.Transfer spreadsheet, but I'm not at all familiar with VB. Here's the macro transfertext transfertext...