Combining Tables

L

Lilbit

I have created a macro which uses several queries to open and append twelve
tables to one table. I typically come up with an error that says "type
conversion failure" even though the column headings are the same and the
data types are the same. Your help would be greatly appreciated.
Thanks!!
 
K

KARL DEWEY

Double check the number fields to be sure that the Field size matches also --
Byte
Integer
Long Integer
Single
Double
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
Adding data to MS Access from csv file 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Cannot sort a table containing text 5
Using VBA and recordset's I need to update 3 relational master tables 1
Start a mail merge upon opening the document 1
Pivot Table - Row Label Combination 0
VBA - (re-) Set a Table Style 2

Top