Search results

Thank you for your replies... I was able to get write access to DB2 and I've created a table in the database. However, I now need to get my local table into the DB2 table. I tried doing this via an append query but it took about 25 minutes for about 8,000 records. Does anyone have any...

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...

Does anyone have any ideas for how to resolve this? Thank you

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...

Thank you Bob, this code was very helpful! :D

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