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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transfer Spreadsheet problem

Status
Not open for further replies.

balllian

MIS
Jan 26, 2005
150
GB
With regards the above im trying to import an excel spreadsheet into an existing table but it says it cant find the file.

I have entered the following in the macro

Transfer Type : Import
Spreadsheet Type : Excel 8-10
Table name : Q33
FileName :J:\INFORMATION\Data_Team\Database\Grad ing Updates\TIC Listing.xls
Field Names :No

It says it cant find the file but it exists and im not in the file. when i do the import manually i cant also import it into an exisiting table.

Im using office 2003.

Any ideas how to get round this???
 
Are u sure the pathname is corrext? try copy pasting it in the explorer.
 
u can try this:

FileName :J:\INFORMATION\Data_Team\Database\Grad.xls



Best Wishes,
sallyGals
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top