Search results

Thanks, but the documentor function isn't quite what I'm looking for. The report format that it provides is static, and I cannot easily pull the connectionstring from the report.

I've been given the menial task of determining the UID and PASSWORD used by each of the linked tables within a few dozen Microsoft 97 databases I support. Is there a way, other than opening each table in design mode and looking at the properties, to see the linked table properties? Perhaps a...

No calculations whatsoever. This spreadsheet was created by microsoft access via the OutputTo command. DoCmd.OutputTo acOutputQuery, "QueryName", acFormatXLS, "filepath\file.xls", True, "" Other spreadsheets import perfectly fine... and once I open the excel spreadsheet it works fine too.

I am having trouble importing data into Microsoft Access 97 from a Microsoft Excel 97 spreadsheet. I am getting the Run-time error '3274', "External table isn't in the expected format." DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "tablename", "c:\file.xls", True...