468,512 Members | 1,561 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,512 developers. It's quick & easy.

asp excel access unique userid

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
2 1874
Rabbit
12,513 Expert Mod 8TB
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
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.

Similar topics

reply views Thread by MARK TURNER | last post: by
1 post views Thread by Jim Heavey | last post: by
4 posts views Thread by BFoxDDS | last post: by
7 posts views Thread by farhaaad | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.