I'm using VBA (TransferText & TransferSpreadsheet) to automatically import various types of files into temporary tables in Access 97. The problem is that Access makes guesses about the data types of the columns based upon the first few hundred records it reviews prior to import. For instance, Access will import an alpha-numeric ID field as Long Integer if the first 500 records all appear to be numeric... during the import, errors are received for IDs containing alpha characters.
Is there any way to force all columns to be imported as text using the TransferText or TransferSpreadsheet methods?
Or, is there a way to force Access to review the all records instead of just the first few hundred prior to assigning data types and importing? I seem to recall that being an option in the Advanced Import Wizard for earlier versions of Access, but don't see it in either 97 or XP.
The files I'm importing do not have any set formats, so I can't set up data import specifications to resolve this headache. Any suggestions will be much appreciated !!
Is there any way to force all columns to be imported as text using the TransferText or TransferSpreadsheet methods?
Or, is there a way to force Access to review the all records instead of just the first few hundred prior to assigning data types and importing? I seem to recall that being an option in the Advanced Import Wizard for earlier versions of Access, but don't see it in either 97 or XP.
The files I'm importing do not have any set formats, so I can't set up data import specifications to resolve this headache. Any suggestions will be much appreciated !!