471,092 Members | 998 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

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 1926
Rabbit
12,516 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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.