Search results

Hello All, I have to run a query against a DB2 table and join it to a local table. My dilemma is that the DB2 table has more than 255 columns some of which I need to return in my query results and these columns are not visible in Access. The DB2 table is very large and my query has no...

I’m not sure if this is the appropriate place for this, but I hope that someone can help…. I’m querying data from an Oracle database using ODBC in MS Access. There is a column in the Oracle table that I’m querying that is formatted as NUMBER(19). When I apply the “to_char” function using...

Is there a way to save an Excel file directly to SharePoint using VBA or maybe VB 6.0? Basically, I have a process that manipulates some data in Access, saves the data to an Excel report, and then saves the report to a share drive. I now need to add in a piece of code that will also save the...

Hello - I need assistance creating a VBA module that converts a vertical bar delimited text file to tab delimited. I cannot use the DoCmd.TransferText method. I do not have to import the file into Access, just do the file conversion in VBA. Can this be done? Thank you in advance