Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to convert a excel file to access file?
- Thread starter jajiyiko
- Start date
LittleSmudge
Programmer
Ahh ?
Do you mean IMPORT and excel SPREADSHEET into an Access TABLE ?
G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.
Do you mean IMPORT and excel SPREADSHEET into an Access TABLE ?
G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.
If its a one-time import, you can use the clipboard...
1) Select the appropriate cells on the worksheet.
2) Copy them
3) Make Access the active application
4) In the database window choose tables
5) Right-click and choose "paste"
A new table will be created automatically.
That is the simplest approach. If you want more control over the process, then use the import wizard....
1) In Access choose "get external data/import" from the file menu.
2) In the import interface, change the "files of type" box to "Microsoft Excel (*.xls)".
3) Find the file and click "okay".
4) Choose the appropriate worksheet. Then complete the wizard (it has several screens.). One tricky part is picking data types for the columns. Remember that "text" is the easiest data type to import.
1) Select the appropriate cells on the worksheet.
2) Copy them
3) Make Access the active application
4) In the database window choose tables
5) Right-click and choose "paste"
A new table will be created automatically.
That is the simplest approach. If you want more control over the process, then use the import wizard....
1) In Access choose "get external data/import" from the file menu.
2) In the import interface, change the "files of type" box to "Microsoft Excel (*.xls)".
3) Find the file and click "okay".
4) Choose the appropriate worksheet. Then complete the wizard (it has several screens.). One tricky part is picking data types for the columns. Remember that "text" is the easiest data type to import.
- Status
Similar threads
- Locked
- Question