Moving report in ODBC to new Access DB

[rynorem]

I've moved tons of text files or Excel files into Access DB's but I need to take an ODBC report and put it into a table on a new Access DB. If I save the report as a text file I get boxes when I import it to the new DB. If I use Excel I have to make a new table each time. Can anyone suggest the simplest way to take an ODBC report and put it into an Access table. THanks

 

[KeithG]

Where is the data stored in another database? You can make a passthrough query to retrieve the data (using the correct ODBC driver) and then make an append query to append the info to your table.