Import External Data (to Excel, from Excel) Misses Data

  • Thread starter Thread starter JanetW
  • Start date Start date
J

JanetW

I had an Excel file with two tabs. One, "Log". was a running log filled
out by processors (non-techie types). The other, "Scorecard", was
various performance metrics calculated based on the log entries. For
various reasons, I had to seperate these into two files. In order to
calculate the scorecard, I used the "Import External Data" so the
scorecard can be recalculated by "Refresh Data" to get the latest
update from the log. In the import wizard, I select the Excel file with
the log in it and then choose the tab that contains the log, "Log$".

There are approx 20 columns of data in the log, 6 of them are date
format. When I import the data, ALL of the column headers are properly
imported, so it seems to reconize the entire table representing the
log. However, there are two anomolies. One I can live with, but the
other is crimpling.

Of the six date columns, two refuse to import any data. The columns and
header are there, but no data. I've tried chaging the column formats,
moving the columns to a different position, and few other things. Any
suggestions on what to do to get the Import Data function to import ALL
the data??

Thanks!!
 
Further attempts to resolve this reveal more weirdness. If I attempt to
import the Log table into Access, it itsists the two problem date
columns are "text" data type. One item to note, the first row of data
does not contain data for several of the columns, included these two
date columns. If I enter dates in the first row of these columns, they
import fine.

Apparently, both Access and Excel use the first row of data to set the
data type, even if I've already predefined the data type in both the
Log and the importing application. Is there any way to override this??
 
Back
Top