append query rounds when it shouldn't

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a table(Table1) in acces2002 that is linked to an excel spreadsheet.
i use an append query to move date from the linked table to another
table(Table2).
a field containing 3 decimal places in Table1 appends to Table2 as rounded
whole numbers.
i've tried changing the format for the field in Table2 and in the excel
spreadsheet, neither worked.
please advise.
Thanks in advance for your time.
 

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

Update or Append Query in Access 2003 2
Help with append query 4
append query 1
append query 7
UnMatched Query 2
query syntax / layout 1
Merging data in a one-to-many relationship 5
Joining two tables 2

Back
Top