importing spreadsheet data

  • Thread starter Thread starter Josh
  • Start date Start date
J

Josh

I am trying to set up a macro in access 2K to import a
excel spreadsheet. I am having trouble with one column in
the spreadsheet which the fields will either have a date
(MM/DD/YY) or the word "HOLD" in them. Access will not
import both the date and the text. I am getting import
errors. Can anyone advize on how to remedy?
 
-----Original Message-----
I am trying to set up a macro in access 2K to import a
excel spreadsheet. I am having trouble with one column in
the spreadsheet which the fields will either have a date
(MM/DD/YY) or the word "HOLD" in them. Access will not
import both the date and the text. I am getting import
errors. Can anyone advize on how to remedy?
.
change your spreadsheet to two columns 1 for date and 1
Click to expand...
for hold
 
Back
Top