importing the correct data type

  • Thread starter Thread starter george
  • Start date Start date
G

george

I have a paper stock report that I receive on a monthly
basis. On this report I base a table in Access. There is a
direct correspondance between the columns on the paper
report and the columns in my table. This is the problem:
the first column in my table, StockName, is based on a
combo box which displays the name of a stock but it stores
a number underneath, for each stock (for performance
reasons of course). On the other hand, I have to scan my
paper report, pass the data to Excel and then import them
from Access. In this case however I have text passed to my
first column, StockName, so I get a message error (text to
a number field). How can I bypass this problem? In general
is there a more efficient way of doing this monthly chore?
 
George,

One way would be to either import form Excel into a temp table (ewith the
first field type Text to hold the name), or just link the Excel sheet, and
then use a query to join the temp table or linked excel sheet with the table
that holds the stock IDs and names on the name fields, to get the
corresponding ID number. This done, you could append from that query.

HTH,
Nikos
 
Back
Top