Recent content by cardinal2k

Hi all, Any idea why the following would cause error 3035, System Resource Exceeded? It's not joining more than 16 tables, and doesn't have any kind of where clause, so the KB article on this error doesn't apply. The db isn't more than 2GB, which is where this call has sometimes failed...

Guys, just for completeness, I'd thought I'd post my solution - I ended up writing a brute force preprocessor to make sure the file is in an acceptable format before being imported by DoCmd.TransferText : It's a little bit scruffy - sorry about the GOTOs. Also, there are constants and functions...

Alas it's on-going, and with occasional (but not too frequent) changes to the import specifications. We did originally use Import specs - they worked fine as you can confirm - but whenever a change was made to the file structure (e.g. a data type shared amongst a lot of the files was changed) it...

There seem to be three alternatives then: 1) I can reinput all the schema.ini entries as Import Specs - from looking around the forum there doesn't seem to be way to do this with VBA, so it'd have to be a manual job and then difficult to maintain. :( 2) In theory, there might be a way to get...

Yep, just checked it. Exactly the same behaviour in Access 2007 - I'm not missing anything in the above code or configuration am I?

Yeah, all the files are different. I wonder if this is still a problem in Access 2007, as our organisation will be upgrading soon.

Is this an absolute rule for TransferText? Given that we are importing about 45 files in total (the above being just an example of one) it's very hard to maintain all those import specifications, especially given the clunky Access interface. That's why we prefer to use the schema.ini which can...

Yep. Here's a sample of the apps.txt file - should have included this earlier for completeness, sorry: APPLICATION_ID;LANGUAGE;APPLICATION_NAME;CREATED_BY;CREATION_DATE;LAST_UPDATED_BY;LAST_UPDATE_DATE;LAST_UPDATE_LOGIN;DESCRIPTION;SOURCE_LANG 0;US;Application Object...

Hi all, Has anyone seen or resolved this kind of behaviour? I'm importing semi-colon delimited files into an Access db with VBA. I'm using a schema.ini, e.g. [apps.txt] CharacterSet = ANSI ColNameHeader = True Format = Delimited( ; ) MaxScanRows=0 [EDIT: The delimiter shows up as a...