Getting #Num! in my ACCESS query

G

Guest

I have a query which gets its data from an Excel spreadsheet and a database.
One of the columns in the Excel spreadsheet is named EDD and contains 4
numeric characters (julian date), but the data is treated as text. In my
query, the data in the EDD field appears as #Num! rather than 4277, for
example. I checked the properties on the linked spreadsheet (table) in ACCESS
and the EDD field says "text". The format on the EDD column in the Excel
spreadsheet is set at "general". I have changed it to "text" and updated the
link in ACCESS, but to no avail. Can anyone help? Thanks.

Jan Buckley
 
K

Ken Snell [MVP]

A number of posts have been made about this issue. Here are some links to
some of them -- you can choose which method you'd like to use:
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
#num! 5
query is not updatable;; urgent 1
How do I detect #NUM! in a Query? 2
Detecting #NUM! in a MS query 2
Append Query - no records with #Num! 6
Refreshing Data Daily From a Linked Excel Spreadsheet 4
#Num! in Link File 1

Top