By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,867 Members | 1,981 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,867 IT Pros & Developers. It's quick & easy.

asp excel access unique userid

P: 8
i m very new to asp and working on a project using asp and access not asp.net……….

I have a small application in which after login, user can upload .xls file, then the record from this excel file is inserted to access database, my sample project files are working fine i.e file uploaded and inserted to access ...my problem is that i want to insert data of that excel file in access with the unique user_id of particular user, because many users can insert excel files to same table, so that when user click on ‘view records’ user should see only his record, not the record of others.
and another thing is that how to save file with unique file name corresponds to the login user to avoid duplication of files... (pls suggest me wht to do… or any other idea……. i really need help…….)
many thanks

this is the url from which I download and using files for upload and insert excel data to access..

shotdev.com/asp/asp-excel/asp-upload-excel-import-to-database/
Jan 6 '12 #1
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,370
In the table where the upload data is stored, create a new column for the user id. Then when it goes to insert a record into that table, just insert the user id along with the file.
Jan 6 '12 #2

P: 8
thank yoy very much i m working on it
Jan 7 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.