Wrong data type when Importing linked tables from one Access Database to
another
I have an access database with some imported tables and some VBA code. I
want to link around 50 .txt files to this database (I cannot import
because of memory constraints). I have an earlier version of the database
where all of the tables that I need have already been linked.
After doing some research, I found that I could "import" these linked
tables - which I understand to mean that the link definition is copied to
my new database. From microsoft's documentation:
"If you import a table that is already linked, then Access does not import
the data; instead, it links the table to its data source (in effect,
copies the link information)."
All the linked tables get imported successfully when I do this. However, I
have found that in a few of my tables the datatypes were not correctly
transferred - fields that were numeric in the original database are now
text. Is there any way to avoid this?
Any help is appreciated!
No comments:
Post a Comment