Recent content by Sean_F_Howard

Thanks for the input Dave, but truthfully it does not help my cause. I CANNOT ask the user to edit the file before importing because they are USERS and will almost certainly screw things up at some point, so I am stuck with dealing with the data in it's original format. I CANNOT use Access to...

Attached are examples of the type of data that I'm trying to import with 3 flavours :- tab delimited text csv excel workbook S.

Thanks a good point PaulO and to be honest it's exactly what I normally do. Originally my source data came as tab-delimited text files, I have an ImportSpecification with 255 text columns and using that everything works fine. So Linking text files was OK, but I needed to make some changes to...

Thanks for replying and I hear what you're saying dude, but I think you missed the point. Firstly regarding the order of the imported data, I do not understand WHY the order changes when importing into a table with NO indicies. Imagine if I was importing a series of instructions or even a...

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

A user of mine recently reported the "The search key was not found in any record" error and my investigation lead me to this forum/thread. The strange thing is that for the table in question the number of records changes (by one) depending on whether the table was unsorted (one record missing)...

DCake, One: An index already exists using the brCode1 & brCode2 fields Two: I don't know, you tell me. Three: Yes and it made no change (the 1million record database is already compacted) Four: Interesting idea, but this would not be possible (or as you say logical) Fine effort though, chap

Firstly the reason I need to update the main table (gemma-the-husky) is that the combined result (main table plus changes) is used in many places throught my database and if I have to ru the updating every time on the fly, it will make all other parts of the database unworkable Secondly I...

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