Import CSV File - One Drive and C Drive
-
- Administrator
- Posts: 78415
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Import CSV File - One Drive and C Drive
The importerrors table should not have a negative impact on performance.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1484
- Joined: 05 Feb 2010, 22:25
Re: Import CSV File - One Drive and C Drive
Good to know. Thanks again for everything.
-
- Administrator
- Posts: 78415
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Import CSV File - One Drive and C Drive
For what it's worth, here is a version that uses a table with possible prefixes and suffixes instead of hard-coding them. So if you need to add more, simply create new records in the table tblItems.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1484
- Joined: 05 Feb 2010, 22:25
Re: Import CSV File - One Drive and C Drive
You are the best!!!! Thanks so much!!