COPY OF LAST MSG'S:
_________________________________________________________
Jul 8, 2002
I keep track of all receipts that I have had since '97 in an Excel '95 spreadsheet. This Excel '95 spreadsheet has only 3 columns but has 3,000(3K) rows. I tried to move this to an Access '00 database for programming purposes. I found this to be very painful. I had to move highlight the row in Excel '95, Then copy this, Then go to my ACCESS '00 and paste it. I did that for 5 records and I gave up. I tried highlighting some records(and later all records) but it would not allow me to copy and paste more than 1 record at a time.
IS THERE ANY WAY TO RESTORE THE EXCEL FILE TO IT'S ORIGINAL STATUS.
Any ideas or suggestions on how to do this faster???
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
mstrmage1768 (Programmer) Jul 8, 2002
Open up your access database, in the menu bar, click Files -> Get External Data -> Import. Change the file type to Excel and navigate to you file....check your field types in the import wizard, etc (I Typically leave the default), and finish the import. Then move/manipulate the data as necessary to have it where and how you want it.
The secret to creativity is knowing how to hide your sources. - Albert Einstein
Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
__________________________________________________________
7/9/02
I did what was suggested and I was able to do this alright but I did notice some records in error(Access Error Log File). I corrected these in ACCESS and when I tried to go back into Excel and correct those it told me that the file was read-only and it could not be modified. IS THERE A WAY TO UNLOCK THE CONSTRAINTS THAT WERE PUT ON MY EXCEL FILE???
_________________________________________________________
Jul 8, 2002
I keep track of all receipts that I have had since '97 in an Excel '95 spreadsheet. This Excel '95 spreadsheet has only 3 columns but has 3,000(3K) rows. I tried to move this to an Access '00 database for programming purposes. I found this to be very painful. I had to move highlight the row in Excel '95, Then copy this, Then go to my ACCESS '00 and paste it. I did that for 5 records and I gave up. I tried highlighting some records(and later all records) but it would not allow me to copy and paste more than 1 record at a time.
IS THERE ANY WAY TO RESTORE THE EXCEL FILE TO IT'S ORIGINAL STATUS.
Any ideas or suggestions on how to do this faster???
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
mstrmage1768 (Programmer) Jul 8, 2002
Open up your access database, in the menu bar, click Files -> Get External Data -> Import. Change the file type to Excel and navigate to you file....check your field types in the import wizard, etc (I Typically leave the default), and finish the import. Then move/manipulate the data as necessary to have it where and how you want it.
The secret to creativity is knowing how to hide your sources. - Albert Einstein
Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
__________________________________________________________
7/9/02
I did what was suggested and I was able to do this alright but I did notice some records in error(Access Error Log File). I corrected these in ACCESS and when I tried to go back into Excel and correct those it told me that the file was read-only and it could not be modified. IS THERE A WAY TO UNLOCK THE CONSTRAINTS THAT WERE PUT ON MY EXCEL FILE???
