Search results

I have a problem when importing an Excel workbook into an Access database. Basically Access does not seem to completely import any row whose total number of characters is more than approx. 1800? I know this doesn't really make sense but the example should make things clearer. You'll need to...

I have a (quite) specific question but I thing it covers something I simply cannot answer. I have three UPDATE queries running on linked tables in Microsoft Access (2000/XP). My main data table (the one to be updated) has almost 1million records My three information tables ALL have primary...

I have an application that uses the DoCmd.TransferText method in MANY places. Until now this has worked fine as I have several "Specifications" depending on the various structure of the data to be imported/exported. I now need to (sometimes) use a specific CodePage with the TransferText method...