I had a similar problem importing an Excel spreadsheet into Access 2000. The spreadsheet had many cells containing over 250 characters and Access refused to recognize the data from Excel as anything but text (250 limitation).
My solution:
1. Import the Excel file into a new Access table.
2...
Thanks PGK and RookieDev for your responses.
Here's a little more detail on the tables I am considering.
I have decided upon 3 tables so far:
RESERVATION
ReservationID (autonumber)
ArriveDate
DepartDate
UnitID
NumNights (calculated)
NumPersons
GuestID
GUEST
GuestID (autonumber)
FirstName...
Thanks for your reply, Darrylle.
I have decided upon 3 tables so far:
RESERVATION
ReservationID (autonumber)
ArriveDate
DepartDate
UnitID
NumNights (calculated)
NumPersons
GuestID
GUEST
GuestID (autonumber)
FirstName
LastName
Street
City
State
Zip
Country
Phone
Email
UNIT
UnitID...
I'm trying to create a cabin rental reservation system in Access. I'm not sure how to keep track of dates reserved and dates available for each rental unit. There are only four rental units and availability dates start on Memorial Day and end on Labor Day. So far I have identified a need for...
I'm trying to create a cabin rental reservation system in Access. I'm not sure how to keep track of dates reserved and dates available for each rental unit. There are only four rental units and availability dates start on Memorial Day and end on Labor Day. So far I have identified a need for...
I'm trying to create a cabin rental reservation system in Access. I'm not sure how to keep track of dates reserved and dates available for each rental unit. There are only four rental units and availability dates start on Memorial Day and end on Labor Day. So far I have identified a need for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.