Problem importing data into linked table

  • Thread starter Thread starter M. Wilson
  • Start date Start date
M

M. Wilson

Hello,

I have several tables linked into an Access 2007 accdb from an Access 2007
accdb. I am trying to import data from a .txt file into the linked tables.

When I try to import the data from the .txt file into the linked tables I
get an error message and no data is imported. However, when I import the
exact same data using the same methiod into the tables in the actual database
where they are stored, I do not receive an error message and the data is
imported fine.

I have imported data into linked tables in previous versions of Access with
no problem.

Can anyone tell me why I would be having trouble importing data in a linked
Access 2007 table?

Much appreciated,
 
Upfront - I do not know the answer & will be interested if an MVP does since
I am always now interested in learning more about the differences in 07.

As a workaround idea however; import it into a new table in your front end.
then run an append query of this new table toward the linked table
destination....that definitely should work. you can easily string together
these two events with vba or a macro.....
 
[color=black:2bv0vfu3]Be a professional Maple Story Store, We supply the maple story mesos[/color:2bv0vfu3][/url:2bv0vfu3]all servers, such as Bellocan, Bera, Broa, Khaini, Scania and Windia. Not only this, We provide the items and other gaming services, such as world of wracraft,guild wars,runescape and so on. [/ (http://www.ugamegold.com/c_Maple-Story-Mesos/:2bv0vfu3)
 
Back
Top