Trying to Import in Access Data Project

[bconner]

I have an Access(2003) Data Project that is connected to a Sql Server 2008 Express. I am trying to import a text file into one of the tables using the Import Wizard but I get an error message saying it doesn't recognize the table I am trying to import into...

I have a primary key set on the table so it can accept entries

 

[Trevor G]

Have you tried using the MACRO section and look for transferText in the arguments it will assist you.

If you are using Access 2007 then when you create a MACRO at the top you have to select to include Show All Commands