When importing Multiple excels, How to Delete first row and Replace that row with Autonumb

Hi All,

I have come across a new scenario,When importing Multiple excel data, How to Delete the first Column and that Column Replace with Auto Number which is primary key in my table. I need with Visual basic coding. Please help me as soon as possible. Thank you for your support

Are you referring to rows or columns. I don't understand your issue. I suspect that you have not received a response because your explanation is not clear. Please try again with examples of what you are attempting. Perhaps even some dummy worksheets of what your data looks like and how you would like it to look would be helpful. Pictures are so much easier to understand.

Use the transferspreadsheet function. Make sure that you have named a range in Excel that excludes the first column. Access will add a new primary key automatically when it imports the file.

Look here for further information

http://msdn.microsoft.com/en-us/libr...ffice.10).aspx