importing spreadsheet data

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?
 
L

larry

-----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
 

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

import dates from excel spreadsheet (problem?) 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
importing dates (problem) 1
Format Excel columns with VB code. 3
Import spreadsheet with modified date 1
Importing Excel spreadsheet 21
Import Spreadsheet Wizard 10
Help on Importing a Date/Time Data Type 4

Top