Recent content by CravenStu

This is driving me mad, please help. I have written the follow code; DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, strImportTable, strImportFilePath, True, "200508!A:F" 200508 is the sheet name. When I run the code I geta message saying 'can't find object '200508$A:F'. Why...

Hi I am trying to view the results of a Access 97 query using 'Get external data' in MS Excel. I have been doing this for quite a while now and it works fine. But I have made some changes to the database and when I try a connect to it now in Excel I get the following error message. 'String...

I am trying to import a large text file into Access97, but it is treating the whole text file as one line. I think there are no carriage return in the text file. It is a huge file, so is there an easy way of importing the file.

Thanks mkelly I tried that, but because it is Access 97 that functionality is not available.

Hi I developed an Access 97 database a year ago to import 120,000 lines of data and create various outputs. A year on it is now importing 1.4 millions lines of data and the queries that analyse the data are taking forever. I have run the database analyser nd everthing looks ok. I have 2...

Can anyone please help. I am trying to create a form button that will allow a user to export a table to a new excel spreadsheet. When the button is clicked I need the explorer window to open in the same directory the application is in, and alow the user to select a new name ,and if need, go to...