Import CSV File - One Drive and C Drive

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Import CSV File - One Drive and C Drive

Post by HansV »

The importerrors table should not have a negative impact on performance.
Best wishes,
Hans

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Import CSV File - One Drive and C Drive

Post by Leesha »

Good to know. Thanks again for everything.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Import CSV File - One Drive and C Drive

Post by HansV »

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.

Leesha.zip
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Import CSV File - One Drive and C Drive

Post by Leesha »

You are the best!!!! Thanks so much!!