Saved Imoorts problem with file name - Microsoft: Access Tables and Relationships

<!DOCTYPE html> <html id="XF" lang="en-US" dir="LTR" data-app="public" data-template="thread_view_type_question" data-container-key="node-700" data-content-key="thread-1820222" data-logged-in="false" data-cookie-prefix="xf_" data-csrf="1739910383,2cf68ef154384486935033873e1cc858" class="has-no-js template-thread_view_type_question XenBase layout-classic style-light sidebar-right xb-toggle-default xb-sidebar-show" > <head> <meta charset="utf-8" /> <meta http-equiv="X-UA-Compatible" content="IE=Edge" /> <meta name="viewport" content="width=device-width, initial-scale=1, viewport-fit=cover">  <script> var dimensionValue1 = 'Programmers'; var dimensionValue2 = 'DBMS Packages'; var dimensionValue3 = 'Microsoft: Access Tables and Relationships'; window.dataLayer = window.dataLayer || []; window.dataLayer.push({ 'Area' : dimensionValue1, 'Category' : dimensionValue2, 'Forum' : dimensionValue3 }); </script>   <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-MMC9PJ9');</script>   <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-TZQ8TVZR');</script>   <script type="text/javascript"> adroll_adv_id = "KCG7QJRNGNEX3GEZSJPEFG"; adroll_pix_id = "HNHCAFVMNNC7FBZP3GMMLE"; adroll_version = "2.0"; (function(w, d, e, o, a) { w.__adroll_loaded = true; w.adroll = w.adroll || []; w.adroll.f = [ 'setProperties', 'identify', 'track', 'identify_email' ]; var roundtripUrl = "https://s.adroll.com/j/" + adroll_adv_id + "/roundtrip.js"; for (a = 0; a < w.adroll.f.length; a++) { w.adroll[w.adroll.f[a]] = w.adroll[w.adroll.f[a]] || (function(n) { return function() { w.adroll.push([ n, arguments ]) } })(w.adroll.f[a]) } e = d.createElement('script'); o = d.getElementsByTagName('script')[0]; e.async = 1; e.src = roundtripUrl; o.parentNode.insertBefore(e, o); })(window, document); adroll.track("pageView"); </script> <script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-4401622383960692" crossorigin="anonymous"></script>   <script async src="https://securepubads.g.doubleclick.net/tag/js/gpt.js"></script> <script> window.googletag = window.googletag || {cmd: []}; googletag.cmd.push(function() { var pathParts = window.location.pathname.substr(1).split('/'); var mapLeaderboard = googletag.sizeMapping() .addSize([1024, 200], [728, 90]) .addSize([0, 0], [300, 250]) .build(); var mapWallpaper = googletag.sizeMapping() .addSize([1024, 200], [1, 1]) .addSize([0, 0], [[1, 1]]) .build(); var gptSlots = []; googletag.defineSlot('/5272491/dw_network/tektips_customsearchbox', [300, 90], 'div-gpt-tektips_customsearchbox').addService(googletag.pubads()); gptSlots[1] = googletag.defineSlot('/5272491/dw_network/tektips_thread1', [728, 90], 'div-gpt-tektips_thread1').defineSizeMapping(mapLeaderboard).addService(googletag.pubads()); gptSlots[2] = googletag.defineSlot('/5272491/dw_network/tektips_thread2', [728, 90], 'div-gpt-tektips_thread2').defineSizeMapping(mapLeaderboard).addService(googletag.pubads()); googletag.defineSlot('/5272491/dw_network/tektips_thread3', [[728, 90]], 'div-gpt-tektips_thread3').addService(googletag.pubads()); gptSlots[3] = googletag.defineSlot('/5272491/dw_network/tektips_wallpaper', [1, 1], 'div-gpt-tektips_wallpaper').defineSizeMapping(mapWallpaper).addService(googletag.pubads()); googletag.defineSlot('/5272491/dw_network/tektips_sidebar1', [[300, 250], [300, 600]], 'div-gpt-tektips_sidebar1').addService(googletag.pubads()); googletag.defineSlot('/5272491/dw_network/tektips_sidebarbottom', [[300, 250], [300, 600],[160, 600]], 'div-gpt-tektips_sidebarbottom').addService(googletag.pubads()); googletag.pubads().enableSingleRequest(); googletag.pubads().collapseEmptyDivs(); googletag.pubads().setTargeting('articletitle', pathParts[0] ? pathParts[0] : 'home-page'); googletag.enableServices(); }); </script>  <title>Saved Imoorts problem with file name - Microsoft: Access Tables and Relationships | Tek-Tips</title> <link rel="manifest" href="/webmanifest.php"> <meta name="theme-color" content="#647ec4" /> <meta name="apple-mobile-web-app-title" content="Tek-Tips Information Technology Professional Forums"> <meta name="description" content="Hi, My work flow is to download a table as a csv from a third party and then save it as an xlsx file. I give it a new filename when I do a saveas xlsx..." /> <meta property="og:description" content="Hi, My work flow is to download a table as a csv from a third party and then save it as an xlsx file. I give it a new filename when I do a saveas xlsx, because the default filename from the third party has special characters in it that are not compatible with access import. The import works..." /> <meta property="twitter:description" content="Hi, My work flow is to download a table as a csv from a third party and then save it as an xlsx file. I give it a new filename when I do a saveas xlsx, because the default filename from the..." /> <meta property="og:url" content="https://www.tek-tips.com/threads/saved-imoorts-problem-with-file-name.1820222/" /> <link rel="canonical" href="https://www.tek-tips.com/threads/saved-imoorts-problem-with-file-name.1820222/" /> <meta property="og:site_name" content="Tek-Tips" /> <meta property="og:type" content="website" /> <meta property="og:title" content="Saved Imoorts problem with file name - Microsoft: Access Tables and Relationships" /> <meta property="twitter:title" content="Saved Imoorts problem with file name - Microsoft: Access Tables..." /> <link rel="preconnect" href="https://fonts.googleapis.com"><link rel="preconnect" href="https://fonts.gstatic.com" crossorigin><link href="https://fonts.googleapis.com/css2?family=Poppins:wght@400;700&display=swap" rel="stylesheet"> <link rel="preload" href="/styles/fonts/fa/fa-light-300.woff2?_v=5.15.3" as="font" type="font/woff2" crossorigin="anonymous" /> <link rel="preload" href="/styles/fonts/fa/fa-solid-900.woff2?_v=5.15.3" as="font" type="font/woff2" crossorigin="anonymous" /> <link rel="preload" href="/styles/fonts/fa/fa-brands-400.woff2?_v=5.15.3" as="font" type="font/woff2" crossorigin="anonymous" /> <link rel="stylesheet" href="/css.php?css=public%3Anormalize.css%2Cpublic%3Afa.css%2Cpublic%3Acore.less%2Cpublic%3Aapp.less&s=3&l=1&d=1735569278&k=0e1337d98c8845c72b8d3c46d22feb00bc113906" /> <link rel="stylesheet" href="/css.php?css=public%3Abb_code.less%2Cpublic%3Amessage.less%2Cpublic%3Anotices.less%2Cpublic%3Ashare_controls.less%2Cpublic%3Asnog_groups.less%2Cpublic%3Astructured_list.less%2Cpublic%3AsvESE_autocomplete.less%2Cpublic%3Axb.less%2Cpublic%3Axb_search.less%2Cpublic%3Axb_sidebar_login.less%2Cpublic%3Axb_welcome.less%2Cpublic%3Axc_soft_attachment.less%2Cpublic%3Axc_votes_button.less%2Cpublic%3Aextra.less&s=3&l=1&d=1735569278&k=cdb114f94fbe34f4b5ca46359adaa4f343adaea1" /> <script src="/js/xf/preamble.min.js?_v=40da5a00"></script> </head> <body data-template="thread_view_type_question">  <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-MMC9PJ9" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>   <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-TZQ8TVZR" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>  <div class="p-pageWrapper" id="top"> <div class="p-pageWrapper--helper"></div> <div class="xb-page-wrapper xb-canvas-menuActive"> <div class="xb-page-wrapper--helper"></div> <header class="p-header" id="header"> <div class="p-header-inner"> <div class="p-header-content"> <div class="p-header-logo p-header-logo--image"> <a href="https://www.tek-tips.com"> <img src="/styles/nova/tek-tips/header-logo.png" srcset="" alt="Tek-Tips" width="" height="" /> </a> </div> <div class="xb-searchWrapper" id="xb-searchWrapper" tabindex="0"> <form action="/search/search" id="xbSearch" data-xf-init="quick-search" data-autocomplete-filter="null" data-autocomplete-filter="null" class="xb-search" method="post" data-no-auto-focus="true"> <input type="text" class="input" name="keywords" placeholder="Search…" aria-label="Search" /> <div class="menu menu--structural menu--search" aria-hidden="true"> <div class="menu-content"> <div class="menu-row"> <select name="constraints" class="js-quickSearch-constraint input" aria-label="Search within"> <option value="">Everywhere</option> <option value="{"search_type":"post"}">Threads</option> <option value="{"search_type":"post","c":{"nodes":[700],"child_nodes":1}}">This forum</option> <option value="{"search_type":"post","c":{"thread":1820222}}">This thread</option> </select> </div> <div class="menu-row"> <label class="iconic"><input type="checkbox" name="c[container_only]" value="1" /><i aria-hidden="true"></i><span class="iconic-label">Search titles and first posts only</span></label> </div> <div class="menu-row"> <label class="iconic"><input type="checkbox" name="c[title_only]" value="1" /><i aria-hidden="true"></i><span class="iconic-label">Search titles only</span></label> </div> <div class="menu-row"> <div class="inputGroup"> <span class="inputGroup-text" id="ctrl_search_menu_by_member">By:</span> <input type="text" class="input" name="c[users]" data-xf-init="auto-complete" placeholder="Member" aria-labelledby="ctrl_search_menu_by_member" /> </div> </div> <div class="menu-footer"> <span class="menu-footer-controls"> <button type="submit" class="button--primary button button--icon button--icon--search"><span class="button-text">Search</span></button> <a href="/search/" class="button"><span class="button-text">Advanced search…</span></a> </span> </div> <input type="hidden" name="_xfToken" value="1739910383,2cf68ef154384486935033873e1cc858" /> </div> </div> </form> </div> </div> </div> </header> <div class="xb-content-wrapper"> <div class="navigation-helper"></div> <div class="p-navSticky p-navSticky--primary" data-xf-init="sticky-header"> <div class="p-nav--wrapper"> <nav class="p-nav"> <div class="p-nav-inner"> <button type="button" class="button--plain p-nav-menuTrigger button" data-xf-click="off-canvas" data-menu=".js-headerOffCanvasMenu" tabindex="0" aria-label="Menu"><span class="button-text"> <i aria-hidden="true"></i> </span></button> <div class="p-nav-smallLogo"> <a href="https://www.tek-tips.com"> <img src="/styles/nova/tek-tips/header-logo.png" srcset="" alt="Tek-Tips" width="" height="" /> </a> </div> <div class="p-nav-scroller hScroller" data-xf-init="h-scroller" data-auto-scroll=".p-navEl.is-selected"> <div class="hScroller-scroll"> <ul class="p-nav-list js-offCanvasNavSource"> <li class="navhome"> <div class="p-navEl " > <a href="https://www.tek-tips.com" class="p-navEl-link " data-xf-key="1" data-nav-id="home">Home</a> </div> </li> <li class="navforums"> <div class="p-navEl is-selected" data-has-children="true"> <a href="/" class="p-navEl-link p-navEl-link--splitMenu " data-nav-id="forums">Forums</a> <a data-xf-key="2" data-xf-click="menu" data-menu-pos-ref="< .p-navEl" class="p-navEl-splitTrigger" role="button" tabindex="0" aria-label="Toggle expanded" aria-expanded="false" aria-haspopup="true"></a> <div class="menu menu--structural" data-menu="menu" aria-hidden="true"> <div class="menu-content"> <a href="/whats-new/posts/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="newPosts">New posts</a> <a href="/search/?type=post" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="searchForums">Search forums</a> <a href="/forums/microsoft-access-tables-and-relationships.700/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="0">Forum</a> <a href="/forums/700/faqs/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy faqLink" data-nav-id="1">FAQs</a> <a href="/forums/700/links/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="2">Links</a> <a href="/forums/700/mvps/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy mvpLink" data-nav-id="3">MVPs</a> </div> </div> </div> </li> <li class="navwhatsNew"> <div class="p-navEl " data-has-children="true"> <a href="/whats-new/" class="p-navEl-link p-navEl-link--splitMenu " data-nav-id="whatsNew">What's new</a> <a data-xf-key="3" data-xf-click="menu" data-menu-pos-ref="< .p-navEl" class="p-navEl-splitTrigger" role="button" tabindex="0" aria-label="Toggle expanded" aria-expanded="false" aria-haspopup="true"></a> <div class="menu menu--structural" data-menu="menu" aria-hidden="true"> <div class="menu-content"> <a href="/whats-new/posts/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " rel="nofollow" data-nav-id="whatsNewPosts">New posts</a> <a href="/whats-new/profile-posts/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " rel="nofollow" data-nav-id="whatsNewProfilePosts">New profile posts</a> <a href="/whats-new/latest-activity" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " rel="nofollow" data-nav-id="latestActivity">Latest activity</a> </div> </div> </div> </li> <li class="navmembers"> <div class="p-navEl " data-has-children="true"> <a href="/members/" class="p-navEl-link p-navEl-link--splitMenu " data-nav-id="members">Members</a> <a data-xf-key="4" data-xf-click="menu" data-menu-pos-ref="< .p-navEl" class="p-navEl-splitTrigger" role="button" tabindex="0" aria-label="Toggle expanded" aria-expanded="false" aria-haspopup="true"></a> <div class="menu menu--structural" data-menu="menu" aria-hidden="true"> <div class="menu-content"> <a href="/online/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="currentVisitors">Current visitors</a> <a href="/whats-new/profile-posts/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " rel="nofollow" data-nav-id="newProfilePosts">New profile posts</a> <a href="/search/?type=profile_post" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="searchProfilePosts">Search profile posts</a> </div> </div> </div> </li> </ul> </div> </div> <div class="p-nav-opposite"> <div class="p-navgroup p-account p-navgroup--guest"> <a href="/login/" class="p-navgroup-link p-navgroup-link--textual p-navgroup-link--logIn" data-xf-click="overlay" data-follow-redirects="on"> <span class="p-navgroup-linkText">Log in</span> </a> <a href="/register/" class="p-navgroup-link p-navgroup-link--textual p-navgroup-link--register" data-xf-click="overlay" data-follow-redirects="on"> <span class="p-navgroup-linkText">Register</span> </a> </div> <div class="p-navgroup p-discovery"> <a href="/whats-new/" class="p-navgroup-link p-navgroup-link--iconic p-navgroup-link--whatsnew" aria-label="What's new" title="What's new"> <i aria-hidden="true"></i> <span class="p-navgroup-linkText">What's new</span> </a> <a href="/search/" class="p-navgroup-link p-navgroup-link--iconic p-navgroup-link--search" data-xf-click="menu" data-xf-key="/" aria-label="Search" aria-expanded="false" aria-haspopup="true" title="Search"> <i aria-hidden="true"></i> <span class="p-navgroup-linkText">Search</span> </a> <div class="menu menu--structural menu--wide" data-menu="menu" aria-hidden="true"> <form action="/search/search" method="post" class="menu-content" data-xf-init="quick-search" data-autocomplete-filter="["post"]"> <h3 class="menu-header">Search</h3> <div class="menu-row"> <div class="inputGroup inputGroup--joined"> <input type="text" class="input" name="keywords" placeholder="Search…" aria-label="Search" data-menu-autofocus="true" /> <select name="constraints" class="js-quickSearch-constraint input" aria-label="Search within"> <option value="">Everywhere</option> <option value="{"search_type":"post"}">Threads</option> <option value="{"search_type":"post","c":{"nodes":[700],"child_nodes":1}}">This forum</option> <option value="{"search_type":"post","c":{"thread":1820222}}" data-suggest-optout="1">This thread</option> </select> </div> </div> <div class="menu-row"> <label class="iconic"><input type="checkbox" name="c[container_only]" value="1" /><i aria-hidden="true"></i><span class="iconic-label">Search titles and first posts only</span></label> </div> <div class="menu-row"> <label class="iconic"><input type="checkbox" name="c[title_only]" value="1" /><i aria-hidden="true"></i><span class="iconic-label">Search titles only</span></label> </div> <div class="menu-row"> <div class="inputGroup"> <span class="inputGroup-text" id="ctrl_search_menu_by_member">By:</span> <input type="text" class="input" name="c[users]" data-xf-init="auto-complete" placeholder="Member" aria-labelledby="ctrl_search_menu_by_member" /> </div> </div> <div class="menu-footer"> <span class="menu-footer-controls"> <button type="submit" class="button--primary button button--icon button--icon--search"><span class="button-text">Search</span></button> <a href="/search/" class="button"><span class="button-text">Advanced search…</span></a> </span> </div> <input type="hidden" name="_xfToken" value="1739910383,2cf68ef154384486935033873e1cc858" /> </form> </div> </div> </div> </div> </nav> </div> </div> <div class="p-sectionLinks--wrapper"> <div class="p-sectionLinks"> <div class="p-sectionLinks-inner"> <div class="hScroller" data-xf-init="h-scroller"> <div class="hScroller-scroll"> <ul class="p-sectionLinks-list"> <li> <div class="p-navEl " > <a href="/whats-new/posts/" class="p-navEl-link " data-xf-key="alt+1" data-nav-id="newPosts">New posts</a> </div> </li> <li> <div class="p-navEl " > <a href="/search/?type=post" class="p-navEl-link " data-xf-key="alt+2" data-nav-id="searchForums">Search forums</a> </div> </li> <li> <div class="p-navEl " > <a href="/forums/microsoft-access-tables-and-relationships.700/" class="p-navEl-link " data-xf-key="alt+3" data-nav-id="0">Forum</a> </div> </li> <li> <div class="p-navEl " > <a href="/forums/700/faqs/" class="p-navEl-link faqLink" data-xf-key="alt+4" data-nav-id="1">FAQs</a> </div> </li> <li> <div class="p-navEl " > <a href="/forums/700/links/" class="p-navEl-link " data-xf-key="alt+5" data-nav-id="2">Links</a> </div> </li> <li> <div class="p-navEl " > <a href="/forums/700/mvps/" class="p-navEl-link mvpLink" data-xf-key="alt+6" data-nav-id="3">MVPs</a> </div> </li> </ul> </div> </div> <div class="p-sectionLinks-right"> </div> </div> </div> </div> <div class="offCanvasMenu offCanvasMenu--nav js-headerOffCanvasMenu" data-menu="menu" aria-hidden="true" data-ocm-builder="navigation"> <div class="offCanvasMenu-backdrop" data-menu-close="true"></div> <div class="offCanvasMenu-content"> <div class="offCanvasMenu-content--inner"> <div class="offCanvasMenu-header"> Menu <a class="offCanvasMenu-closer" data-menu-close="true" role="button" tabindex="0" aria-label="Close"></a> </div> <div class="p-offCanvasRegisterLink"> <div class="offCanvasMenu-linkHolder"> <a href="/login/" class="offCanvasMenu-link" data-xf-click="overlay" data-menu-close="true"> Log in </a> </div> <hr class="offCanvasMenu-separator" /> <div class="offCanvasMenu-linkHolder"> <a href="/register/" class="offCanvasMenu-link" data-xf-click="overlay" data-menu-close="true"> Register </a> </div> <hr class="offCanvasMenu-separator" /> </div> <div class="offCanvasMenu-subHeader">Navigation</div> <div class="js-offCanvasNavTarget"></div> <div class="offCanvasMenu-installBanner js-installPromptContainer" style="display: none;" data-xf-init="install-prompt"> <div class="offCanvasMenu-installBanner-header">Install the app</div> <button type="button" class="js-installPromptButton button"><span class="button-text">Install</span></button> <template class="js-installTemplateIOS"> <div class="overlay-title">How to install the app on iOS</div> <div class="block-body"> <div class="block-row"> <p> Follow along with the video below to see how to install our site as a web app on your home screen. </p> <p style="text-align: center"> <video src="/styles/default/xenforo/add_to_home.mp4" width="280" height="480" autoplay loop muted playsinline></video> </p> <p> <small><strong>Note:</strong> This feature may not be available in some browsers.</small> </p> </div> </div> </template> </div> <div class="offCanvasMenu-subHeader">More options</div> <div class="offCanvasMenu-linkHolder"> <a href="/misc/contact" class="offCanvasMenu-link" data-menu-close="true" data-nav-id="contactUs" data-xf-click="overlay">Contact us</a> </div> <div class="offCanvasMenu-linkHolder"> <a class="offCanvasMenu-link" data-menu-close="true" data-nav-id="closeMenu" role="button" tabindex="0" aria-label="Close">Close Menu</a> </div> </div> </div> </div> <div class="p-body"> <div class="p-body-inner"> <div class="xb-welcome-notice"> <div class="xb-welcome-notice--mask"> <div class="xb-welcome-notice--inner"> <div class="xb-welcome-notice--title"> <h3>Tek-Tips is the largest IT community on the Internet today!</h3> <h4>Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!</h4> </div> <div class="xb-welcome-notice--buttons"> <a href="/register/" class="button" data-xf-click="overlay" data-follow-redirects="on"><span class="button-text">Register</span></a> <a href="/login/" class="button--cta button" rel="nofollow" data-xf-click="overlay" data-menu-close="true"> <span class="button-text">Log in</span> </a> </div> </div> </div> </div>  <ul class="notices notices--block js-notices" data-xf-init="notices" data-type="block" data-scroll-interval="6"> <li class="notice js-notice notice--light" data-notice-id="28" data-delay-duration="0" data-display-duration="0" data-auto-dismiss="" data-visibility=""> <div class="notice-content"> <b>Congratulations <span><a href="/members/sizbut.623214/">sizbut</a></span></b> on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go! </div> </li> </ul> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread1'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread1'); }); </script> </div> </div> </div><div> <div class="p-breadcrumbs--parent "> <ul class="p-breadcrumbs " itemscope itemtype="https://schema.org/BreadcrumbList"> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="https://www.tek-tips.com" itemprop="item"> <span itemprop="name">Home</span> </a> <meta itemprop="position" content="1" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/" itemprop="item"> <span itemprop="name">Forums</span> </a> <meta itemprop="position" content="2" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/#software.1001" itemprop="item"> <span itemprop="name">Software</span> </a> <meta itemprop="position" content="3" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/categories/programmers.1004/" itemprop="item"> <span itemprop="name">Programmers</span> </a> <meta itemprop="position" content="4" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/categories/dbms-packages.10027/" itemprop="item"> <span itemprop="name">DBMS Packages</span> </a> <meta itemprop="position" content="5" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/forums/microsoft-access-tables-and-relationships.700/" itemprop="item"> <span itemprop="name">Microsoft: Access Tables and Relationships</span> </a> <meta itemprop="position" content="6" /> </li> </ul> </div> <noscript class="js-jsWarning"><div class="blockMessage blockMessage--important blockMessage--iconic u-noJsOnly">JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.</div></noscript> <div class="blockMessage blockMessage--important blockMessage--iconic js-browserWarning" style="display: none">You are using an out of date browser. It may not display this or other websites correctly.<br />You should upgrade or use an <a href="https://www.google.com/chrome/" target="_blank" rel="noopener">alternative browser</a>.</div>  <div class="p-body-header"> <div class="p-title "> <h1 class="p-title-value">Saved Imoorts problem with file name </h1> </div> <div class="p-description"> <ul class="listInline listInline--bullet"> <li> <i class="fa--xf fal fa-user" aria-hidden="true" title="Thread starter"></i> <span class="u-srOnly">Thread starter</span> <a href="/members/jayro71.1692646/" class="username u-concealed" dir="auto" data-user-id="1692646" data-xf-init="member-tooltip">JayRo71</a> </li> <li> <i class="fa--xf fal fa-clock" aria-hidden="true" title="Start date"></i> <span class="u-srOnly">Start date</span> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/" class="u-concealed"><time class="u-dt" dir="auto" datetime="2023-01-25T12:28:26+0000" data-time="1674649706" data-date-string="Jan 25, 2023" data-time-string="12:28 PM" title="Jan 25, 2023 at 12:28 PM">Jan 25, 2023</time></a> </li> </ul> </div> </div>  <div class="p-body-main p-body-main--withSidebar "> <div class="p-body-contentCol"></div> <div class="p-body-sidebarCol"></div> <div class="p-body-content">  <div id='div-gpt-tektips_wallpaper'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_wallpaper'); }); </script> </div> <div class="p-body-pageContent"> <div class="block block--messages " data-xf-init="lightbox select-to-quote" data-message-selector=".js-post" data-lb-id="thread-1820222"> <div class="block-outer"> <dl class="blockStatus"> <dt>Status</dt> <dd class="blockStatus-message blockStatus-message--locked"> Not open for further replies. </dd> </dl> </div> <div class="block-outer"></div> <div class="block-outer js-threadStatusField"></div> <div class="block-container"> <div class="block-body"> <article class="message message--post js-post js-inlineModContainer " data-author="JayRo71" data-content="post-7541703" id="js-post-7541703" > <span class="u-anchorTarget" id="post-7541703"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541703" rel="nofollow" > <time class="u-dt" dir="auto" datetime="2023-01-25T12:28:26+0000" data-time="1674649706" data-date-string="Jan 25, 2023" data-time-string="12:28 PM" title="Jan 25, 2023 at 12:28 PM">Jan 25, 2023</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541703" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7541703/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541703" rel="nofollow"> #1 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" > <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/jayro71.1692646/" class="avatar avatar--s" data-user-id="1692646" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="JayRo71" class="avatar-u1692646-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/jayro71.1692646/" class="username " dir="auto" data-user-id="1692646" data-xf-init="member-tooltip">JayRo71</a></h4> <h5 class="userTitle message-userTitle" dir="auto">Technical User</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>May 13, 2020</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>53</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7541703" data-lb-caption-desc="JayRo71 · Jan 25, 2023 at 12:28 PM"> <article class="message-body js-selectToQuote"> <div > <div class="bbWrapper">Hi,<br /> <br /> My work flow is to download a table as a csv from a third party and then save it as an xlsx file. I give it a new filename when I do a saveas xlsx, because the default filename from the third party has special characters in it that are not compatible with access import. <br /> <br /> The import works perfectly and I save the steps as a saved import. I can run this saved import over and over again, with no problems at all. That is, until I download a new csv file from the third party and overwrite the previous xlsx file. For some reason, the saved import, now sees the default file name and disregards the saveas name. Consequently, it lists the original filename from the third party as an invalid file name and halts the import. <br /> <br /> The main reason I want to use a saved import is because I have a field that I need to change to short text instead of a number each time I do the import. Saved import would automate this process. <br /> <br /> I believe that somehow, the excel file logs the original filename somewhere as a constant and it is where Access looks up the filename in its saved import procedure.<br /> <br /> Some things I will try. <br /> <br /> Instead of overwriting the first xlsx file using excel saveas, I will delete the original file before doing the saveas, so I will not be overwriting an existing file. <br /> I will also try renaming the file in the directory tree, rather than renaming it with a saveas. <br /> <br /> Any other ideas as to what is going on or a work around would be helpful. <br /> <br /> Thanks.</div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> </div> </article> </div> </div> </div> <div class="block block--messages" data-xf-init="" data-type="post" data-href="/inline-mod/" data-search-target="*"> <span class="u-anchorTarget" id="posts"></span> <div class="block-outer"><div class="block-outer-opposite"> <div class="tabs tabs--standalone tabs--standalone--small tabs--standalone--inline"> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/" class="tabs-tab is-active" rel="nofollow"> Sort by date </a> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/?order=vote_score" class="tabs-tab " rel="nofollow"> Sort by votes </a> </div> </div></div> <div class="block-container lbContainer" data-xf-init="lightbox select-to-quote" data-message-selector=".js-post" data-lb-id="thread-1820222" data-lb-universal="0"> <div class="block-body js-replyNewMessageContainer"> <article class="message message--post js-post js-inlineModContainer " data-author="JayRo71" data-content="post-7541705" id="js-post-7541705" itemscope itemtype="https://schema.org/Answer" itemid="https://www.tek-tips.com/posts/7541705/"> <meta itemprop="parentItem" itemscope itemid="https://www.tek-tips.com/threads/saved-imoorts-problem-with-file-name.1820222/" /> <span class="u-anchorTarget" id="post-7541705"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541705" rel="nofollow" itemprop="url"> <time class="u-dt" dir="auto" datetime="2023-01-25T12:38:06+0000" data-time="1674650286" data-date-string="Jan 25, 2023" data-time-string="12:38 PM" title="Jan 25, 2023 at 12:38 PM" itemprop="datePublished">Jan 25, 2023</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li class="tag-threadStarter"><span class="message-newIndicator message-threadStarter">Thread starter</span></li> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541705" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7541705/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541705" rel="nofollow"> #2 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" itemprop="author" itemscope itemtype="https://schema.org/Person" itemid="https://www.tek-tips.com/members/jayro71.1692646/"> <meta itemprop="url" content="https://www.tek-tips.com/members/jayro71.1692646/" /> <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/jayro71.1692646/" class="avatar avatar--s" data-user-id="1692646" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="JayRo71" class="avatar-u1692646-s" width="48" height="48" loading="lazy" itemprop="image" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/jayro71.1692646/" class="username " dir="auto" data-user-id="1692646" data-xf-init="member-tooltip"><span itemprop="name">JayRo71</span></a></h4> <h5 class="userTitle message-userTitle" dir="auto" itemprop="jobTitle">Technical User</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>May 13, 2020</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>53</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7541705" data-lb-caption-desc="JayRo71 · Jan 25, 2023 at 12:38 PM"> <article class="message-body js-selectToQuote"> <div itemprop="text"> <div class="bbWrapper">I tried different ways of renaming the xlsx file and none worked. One thing that stands out to me is that Acceess defaults to the original file name when creating the table during the import. I am not at all sure where access is getting that information as the table is already renamed before I try to import it. Maybe this is a known problem?</div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="message-microdata" itemprop="interactionStatistic" itemtype="https://schema.org/InteractionCounter" itemscope> <meta itemprop="userInteractionCount" content="0" /> <meta itemprop="interactionType" content="https://schema.org/LikeAction" /> </div> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> <div class="message-cell message-cell--vote"> <div class="message-column"> <div class="contentVote js-contentVote " data-xf-init="content-vote" data-content-id="post-7541705"> <meta itemprop="upvoteCount" content="0" /> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--up " data-vote="up"><span class="u-srOnly">Upvote</span></a> <span class="contentVote-score js-voteCount" data-score="0">0</span> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--down " data-vote="down"><span class="u-srOnly">Downvote</span></a> </div> </div> </div> </div> </article> <article class="message message--post js-post js-inlineModContainer " data-author="dhookom" data-content="post-7541707" id="js-post-7541707" itemscope itemtype="https://schema.org/Answer" itemid="https://www.tek-tips.com/posts/7541707/"> <meta itemprop="parentItem" itemscope itemid="https://www.tek-tips.com/threads/saved-imoorts-problem-with-file-name.1820222/" /> <span class="u-anchorTarget" id="post-7541707"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541707" rel="nofollow" itemprop="url"> <time class="u-dt" dir="auto" datetime="2023-01-25T12:58:16+0000" data-time="1674651496" data-date-string="Jan 25, 2023" data-time-string="12:58 PM" title="Jan 25, 2023 at 12:58 PM" itemprop="datePublished">Jan 25, 2023</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541707" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7541707/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541707" rel="nofollow"> #3 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" itemprop="author" itemscope itemtype="https://schema.org/Person" itemid="https://www.tek-tips.com/members/dhookom.529593/"> <meta itemprop="url" content="https://www.tek-tips.com/members/dhookom.529593/" /> <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/dhookom.529593/" class="avatar avatar--s" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" srcset="/data/avatars/m/529/529593.jpg?1723729896 2x" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" itemprop="image" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip"><span itemprop="name">dhookom</span></a></h4> <h5 class="userTitle message-userTitle" dir="auto" itemprop="jobTitle">Programmer</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>Jun 24, 2003</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>22,536</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7541707" data-lb-caption-desc="dhookom · Jan 25, 2023 at 12:58 PM"> <article class="message-body js-selectToQuote"> <div itemprop="text"> <div class="bbWrapper">The import specs are saved in two system tables that you could review. I believe the table names begin with msysIMEX…. <br /> <br /> <span style="color: Blue"><b><i>Duane<br /> Minnesota<br /> <a href="http://www.access.hookom.net/" target="_blank" class="link link--external" rel="nofollow ugc noopener">Hook'D on Access</a><br /> MS Access MVP 2001-2016<br /> </i></b></span></div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="message-microdata" itemprop="interactionStatistic" itemtype="https://schema.org/InteractionCounter" itemscope> <meta itemprop="userInteractionCount" content="0" /> <meta itemprop="interactionType" content="https://schema.org/LikeAction" /> </div> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> <div class="message-cell message-cell--vote"> <div class="message-column"> <div class="contentVote js-contentVote " data-xf-init="content-vote" data-content-id="post-7541707"> <meta itemprop="upvoteCount" content="0" /> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--up " data-vote="up"><span class="u-srOnly">Upvote</span></a> <span class="contentVote-score js-voteCount" data-score="0">0</span> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--down " data-vote="down"><span class="u-srOnly">Downvote</span></a> </div> </div> </div> </div> </article> <article class="message message--post js-post js-inlineModContainer " data-author="Andrzejek" data-content="post-7541708" id="js-post-7541708" itemscope itemtype="https://schema.org/Answer" itemid="https://www.tek-tips.com/posts/7541708/"> <meta itemprop="parentItem" itemscope itemid="https://www.tek-tips.com/threads/saved-imoorts-problem-with-file-name.1820222/" /> <span class="u-anchorTarget" id="post-7541708"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541708" rel="nofollow" itemprop="url"> <time class="u-dt" dir="auto" datetime="2023-01-25T13:00:49+0000" data-time="1674651649" data-date-string="Jan 25, 2023" data-time-string="1:00 PM" title="Jan 25, 2023 at 1:00 PM" itemprop="datePublished">Jan 25, 2023</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541708" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7541708/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541708" rel="nofollow"> #4 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" itemprop="author" itemscope itemtype="https://schema.org/Person" itemid="https://www.tek-tips.com/members/andrzejek.1105365/"> <meta itemprop="url" content="https://www.tek-tips.com/members/andrzejek.1105365/" /> <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/andrzejek.1105365/" class="avatar avatar--s" data-user-id="1105365" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="Andrzejek" class="avatar-u1105365-s" width="48" height="48" loading="lazy" itemprop="image" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/andrzejek.1105365/" class="username " dir="auto" data-user-id="1105365" data-xf-init="member-tooltip"><span itemprop="name">Andrzejek</span></a></h4> <h5 class="userTitle message-userTitle" dir="auto" itemprop="jobTitle">Programmer</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>Jan 10, 2006</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>8,550</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7541708" data-lb-caption-desc="Andrzejek · Jan 25, 2023 at 1:00 PM"> <article class="message-body js-selectToQuote"> <div itemprop="text"> <div class="bbWrapper">In this particular case and instance, what I would do:<br /> [ul]<br /> [li]Open your Excel file with your data that causes the issue[/li]<br /> [li]Open another fresh, empty Excel file[/li]<br /> [li]Copy data from your original Excel file[/li]<br /> [li]Paste the data into your ‘fresh’ empty Excel file[/li]<br /> [li]Close your original Excel file and Delete it in Windows Explorer[/li]<br /> [li]Save your remaining Excel file with the name you want[/li]<br /> [li]Do your Access Import again[/li]<br /> [/ul]<br /> <br /> This way the new Excel file should have no association with any previous, old, problematic names. <br /> <br /> Just a suggestion...<br /> <br /> ---- Andy<br /> <br /> <i>"Hmm...they have the internet on computers now"--Homer Simpson</i></div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="message-microdata" itemprop="interactionStatistic" itemtype="https://schema.org/InteractionCounter" itemscope> <meta itemprop="userInteractionCount" content="0" /> <meta itemprop="interactionType" content="https://schema.org/LikeAction" /> </div> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> <div class="message-cell message-cell--vote"> <div class="message-column"> <div class="contentVote js-contentVote " data-xf-init="content-vote" data-content-id="post-7541708"> <meta itemprop="upvoteCount" content="0" /> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--up " data-vote="up"><span class="u-srOnly">Upvote</span></a> <span class="contentVote-score js-voteCount" data-score="0">0</span> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--down " data-vote="down"><span class="u-srOnly">Downvote</span></a> </div> </div> </div> </div> </article> <article class="message message--post js-post js-inlineModContainer " data-author="JayRo71" data-content="post-7541713" id="js-post-7541713" itemscope itemtype="https://schema.org/Answer" itemid="https://www.tek-tips.com/posts/7541713/"> <meta itemprop="parentItem" itemscope itemid="https://www.tek-tips.com/threads/saved-imoorts-problem-with-file-name.1820222/" /> <span class="u-anchorTarget" id="post-7541713"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541713" rel="nofollow" itemprop="url"> <time class="u-dt" dir="auto" datetime="2023-01-25T14:05:29+0000" data-time="1674655529" data-date-string="Jan 25, 2023" data-time-string="2:05 PM" title="Jan 25, 2023 at 2:05 PM" itemprop="datePublished">Jan 25, 2023</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li class="tag-threadStarter"><span class="message-newIndicator message-threadStarter">Thread starter</span></li> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541713" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7541713/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541713" rel="nofollow"> #5 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" itemprop="author" itemscope itemtype="https://schema.org/Person" itemid="https://www.tek-tips.com/members/jayro71.1692646/"> <meta itemprop="url" content="https://www.tek-tips.com/members/jayro71.1692646/" /> <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/jayro71.1692646/" class="avatar avatar--s" data-user-id="1692646" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="JayRo71" class="avatar-u1692646-s" width="48" height="48" loading="lazy" itemprop="image" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/jayro71.1692646/" class="username " dir="auto" data-user-id="1692646" data-xf-init="member-tooltip"><span itemprop="name">JayRo71</span></a></h4> <h5 class="userTitle message-userTitle" dir="auto" itemprop="jobTitle">Technical User</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>May 13, 2020</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>53</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7541713" data-lb-caption-desc="JayRo71 · Jan 25, 2023 at 2:05 PM"> <article class="message-body js-selectToQuote"> <div itemprop="text"> <div class="bbWrapper">Andy, Great suggestion from a troubleshooting standpoint. Abandoning the saved import and doing a new step by step import would be faster though. <br /> dhookum, I will see if I can find out how to access system tables.<br /> <br /> I just setup a VBA import procedure that works great, except I get errors because of the one field that defaults to "double" instead of "short text". the values are mostly digits as they are account numbers, but they create havoc when importing a table. <br /> <br /> So the VBA procedure fixes the filename problem, but I'm back to a datatype problem. <br /> <br /> I found a great video that offered the following code for doing an import. I wonder if there is anywhere I can use VBA to handle the data type. <br /> <br /> Option Compare Database<br /> Option Explicit<br /> <br /> Public Sub ImportExcelSpreadsheet(filename As String, tableName As String)<br /> DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, tableName, filename, True<br /> End Sub<br /> <br /> <br /> <br /> Private Sub btnBrowse_Click()<br /> Dim diag As Office.FileDialog<br /> Dim item As Variant<br /> <br /> Set diag = Application.FileDialog(msoFileDialogFilePicker)<br /> diag.AllowMultiSelect = False<br /> diag.Title = "Please select an Excel Spreadsheet"<br /> diag.Filters.Clear<br /> diag.Filters.Add "Excel Spreadsheets", "*.xls, *.xlsx"<br /> <br /> If diag.Show Then<br /> For Each item In diag.SelectedItems<br /> Me.txtFileName = item<br /> Next<br /> End If<br /> End Sub<br /> <br /> Private Sub btnImportSpreadsheet_Click()<br /> Dim FSO As New FileSystemObject<br /> <br /> If Nz(Me.txtFileName, "") = "" Then<br /> MsgBox "Please select a file!"<br /> Exit Sub<br /> End If<br /> <br /> If FSO.FileExists(Nz(Me.txtFileName)) Then<br /> ExcelImport.ImportExcelSpreadsheet Me.txtFileName, "tblImportTemp"<br /> Else<br /> MsgBox "File not found"<br /> End If<br /> <br /> End Sub<br /> <br /></div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="message-microdata" itemprop="interactionStatistic" itemtype="https://schema.org/InteractionCounter" itemscope> <meta itemprop="userInteractionCount" content="0" /> <meta itemprop="interactionType" content="https://schema.org/LikeAction" /> </div> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> <div class="message-cell message-cell--vote"> <div class="message-column"> <div class="contentVote js-contentVote " data-xf-init="content-vote" data-content-id="post-7541713"> <meta itemprop="upvoteCount" content="0" /> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--up " data-vote="up"><span class="u-srOnly">Upvote</span></a> <span class="contentVote-score js-voteCount" data-score="0">0</span> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--down " data-vote="down"><span class="u-srOnly">Downvote</span></a> </div> </div> </div> </div> </article> <article class="message message--post js-post js-inlineModContainer " data-author="dhookom" data-content="post-7541714" id="js-post-7541714" itemscope itemtype="https://schema.org/Answer" itemid="https://www.tek-tips.com/posts/7541714/"> <meta itemprop="parentItem" itemscope itemid="https://www.tek-tips.com/threads/saved-imoorts-problem-with-file-name.1820222/" /> <span class="u-anchorTarget" id="post-7541714"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541714" rel="nofollow" itemprop="url"> <time class="u-dt" dir="auto" datetime="2023-01-25T14:17:21+0000" data-time="1674656241" data-date-string="Jan 25, 2023" data-time-string="2:17 PM" title="Jan 25, 2023 at 2:17 PM" itemprop="datePublished">Jan 25, 2023</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541714" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7541714/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541714" rel="nofollow"> #6 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" itemprop="author" itemscope itemtype="https://schema.org/Person" itemid="https://www.tek-tips.com/members/dhookom.529593/"> <meta itemprop="url" content="https://www.tek-tips.com/members/dhookom.529593/" /> <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/dhookom.529593/" class="avatar avatar--s" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" srcset="/data/avatars/m/529/529593.jpg?1723729896 2x" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" itemprop="image" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip"><span itemprop="name">dhookom</span></a></h4> <h5 class="userTitle message-userTitle" dir="auto" itemprop="jobTitle">Programmer</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>Jun 24, 2003</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>22,536</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7541714" data-lb-caption-desc="dhookom · Jan 25, 2023 at 2:17 PM"> <article class="message-body js-selectToQuote"> <div itemprop="text"> <div class="bbWrapper">Ben Clothier has an article that might help at <div><a href="https://accessexperts.com/blog/2020/10/21/connection-string-parameters-for-text-file-sources-schema-information/" target="_blank" class="link link--external" rel="nofollow ugc noopener">https://accessexperts.com/blog/2020...ers-for-text-file-sources-schema-information/</a></div><br /> <span style="color: Blue"><b><i>Duane<br /> Minnesota<br /> <a href="http://www.access.hookom.net/" target="_blank" class="link link--external" rel="nofollow ugc noopener">Hook'D on Access</a><br /> MS Access MVP 2001-2016<br /> </i></b></span></div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="message-microdata" itemprop="interactionStatistic" itemtype="https://schema.org/InteractionCounter" itemscope> <meta itemprop="userInteractionCount" content="0" /> <meta itemprop="interactionType" content="https://schema.org/LikeAction" /> </div> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> <div class="message-cell message-cell--vote"> <div class="message-column"> <div class="contentVote js-contentVote " data-xf-init="content-vote" data-content-id="post-7541714"> <meta itemprop="upvoteCount" content="0" /> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--up " data-vote="up"><span class="u-srOnly">Upvote</span></a> <span class="contentVote-score js-voteCount" data-score="0">0</span> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--down " data-vote="down"><span class="u-srOnly">Downvote</span></a> </div> </div> </div> </div> </article> <article class="message message--post js-post js-inlineModContainer " data-author="JayRo71" data-content="post-7541715" id="js-post-7541715" itemscope itemtype="https://schema.org/Answer" itemid="https://www.tek-tips.com/posts/7541715/"> <meta itemprop="parentItem" itemscope itemid="https://www.tek-tips.com/threads/saved-imoorts-problem-with-file-name.1820222/" /> <span class="u-anchorTarget" id="post-7541715"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541715" rel="nofollow" itemprop="url"> <time class="u-dt" dir="auto" datetime="2023-01-25T14:18:34+0000" data-time="1674656314" data-date-string="Jan 25, 2023" data-time-string="2:18 PM" title="Jan 25, 2023 at 2:18 PM" itemprop="datePublished">Jan 25, 2023</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li class="tag-threadStarter"><span class="message-newIndicator message-threadStarter">Thread starter</span></li> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541715" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7541715/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541715" rel="nofollow"> #7 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" itemprop="author" itemscope itemtype="https://schema.org/Person" itemid="https://www.tek-tips.com/members/jayro71.1692646/"> <meta itemprop="url" content="https://www.tek-tips.com/members/jayro71.1692646/" /> <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/jayro71.1692646/" class="avatar avatar--s" data-user-id="1692646" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="JayRo71" class="avatar-u1692646-s" width="48" height="48" loading="lazy" itemprop="image" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/jayro71.1692646/" class="username " dir="auto" data-user-id="1692646" data-xf-init="member-tooltip"><span itemprop="name">JayRo71</span></a></h4> <h5 class="userTitle message-userTitle" dir="auto" itemprop="jobTitle">Technical User</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>May 13, 2020</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>53</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7541715" data-lb-caption-desc="JayRo71 · Jan 25, 2023 at 2:18 PM"> <article class="message-body js-selectToQuote"> <div itemprop="text"> <div class="bbWrapper">I will check it out... Thank you!</div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="message-microdata" itemprop="interactionStatistic" itemtype="https://schema.org/InteractionCounter" itemscope> <meta itemprop="userInteractionCount" content="0" /> <meta itemprop="interactionType" content="https://schema.org/LikeAction" /> </div> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> <div class="message-cell message-cell--vote"> <div class="message-column"> <div class="contentVote js-contentVote " data-xf-init="content-vote" data-content-id="post-7541715"> <meta itemprop="upvoteCount" content="0" /> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--up " data-vote="up"><span class="u-srOnly">Upvote</span></a> <span class="contentVote-score js-voteCount" data-score="0">0</span> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--down " data-vote="down"><span class="u-srOnly">Downvote</span></a> </div> </div> </div> </div> </article> <article class="message message--post js-post js-inlineModContainer " data-author="JayRo71" data-content="post-7541716" id="js-post-7541716" itemscope itemtype="https://schema.org/Answer" itemid="https://www.tek-tips.com/posts/7541716/"> <meta itemprop="parentItem" itemscope itemid="https://www.tek-tips.com/threads/saved-imoorts-problem-with-file-name.1820222/" /> <span class="u-anchorTarget" id="post-7541716"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541716" rel="nofollow" itemprop="url"> <time class="u-dt" dir="auto" datetime="2023-01-25T14:34:24+0000" data-time="1674657264" data-date-string="Jan 25, 2023" data-time-string="2:34 PM" title="Jan 25, 2023 at 2:34 PM" itemprop="datePublished">Jan 25, 2023</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li class="tag-threadStarter"><span class="message-newIndicator message-threadStarter">Thread starter</span></li> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541716" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7541716/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541716" rel="nofollow"> #8 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" itemprop="author" itemscope itemtype="https://schema.org/Person" itemid="https://www.tek-tips.com/members/jayro71.1692646/"> <meta itemprop="url" content="https://www.tek-tips.com/members/jayro71.1692646/" /> <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/jayro71.1692646/" class="avatar avatar--s" data-user-id="1692646" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="JayRo71" class="avatar-u1692646-s" width="48" height="48" loading="lazy" itemprop="image" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/jayro71.1692646/" class="username " dir="auto" data-user-id="1692646" data-xf-init="member-tooltip"><span itemprop="name">JayRo71</span></a></h4> <h5 class="userTitle message-userTitle" dir="auto" itemprop="jobTitle">Technical User</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>May 13, 2020</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>53</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7541716" data-lb-caption-desc="JayRo71 · Jan 25, 2023 at 2:34 PM"> <article class="message-body js-selectToQuote"> <div itemprop="text"> <div class="bbWrapper">dhookum, you definitely pointed me in the right direction. In fact, I went back to the first in the series of articles and I am very intrigued after reading a couple of paragraphs... <br /> The first article is found at <div><a href="https://accessexperts.com/blog/2020/10/19/opening-or-linking-text-or-excel-in-access/" target="_blank" class="link link--external" rel="nofollow ugc noopener">https://accessexperts.com/blog/2020/10/19/opening-or-linking-text-or-excel-in-access/</a></div> and it really got my attention. Thanks!</div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="message-microdata" itemprop="interactionStatistic" itemtype="https://schema.org/InteractionCounter" itemscope> <meta itemprop="userInteractionCount" content="0" /> <meta itemprop="interactionType" content="https://schema.org/LikeAction" /> </div> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> <div class="message-cell message-cell--vote"> <div class="message-column"> <div class="contentVote js-contentVote " data-xf-init="content-vote" data-content-id="post-7541716"> <meta itemprop="upvoteCount" content="0" /> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--up " data-vote="up"><span class="u-srOnly">Upvote</span></a> <span class="contentVote-score js-voteCount" data-score="0">0</span> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--down " data-vote="down"><span class="u-srOnly">Downvote</span></a> </div> </div> </div> </div> </article> <article class="message message--post js-post js-inlineModContainer " data-author="Andrzejek" data-content="post-7541729" id="js-post-7541729" itemscope itemtype="https://schema.org/Answer" itemid="https://www.tek-tips.com/posts/7541729/"> <meta itemprop="parentItem" itemscope itemid="https://www.tek-tips.com/threads/saved-imoorts-problem-with-file-name.1820222/" /> <span class="u-anchorTarget" id="post-7541729"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541729" rel="nofollow" itemprop="url"> <time class="u-dt" dir="auto" datetime="2023-01-25T15:57:33+0000" data-time="1674662253" data-date-string="Jan 25, 2023" data-time-string="3:57 PM" title="Jan 25, 2023 at 3:57 PM" itemprop="datePublished">Jan 25, 2023</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541729" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7541729/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541729" rel="nofollow"> #9 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" itemprop="author" itemscope itemtype="https://schema.org/Person" itemid="https://www.tek-tips.com/members/andrzejek.1105365/"> <meta itemprop="url" content="https://www.tek-tips.com/members/andrzejek.1105365/" /> <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/andrzejek.1105365/" class="avatar avatar--s" data-user-id="1105365" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="Andrzejek" class="avatar-u1105365-s" width="48" height="48" loading="lazy" itemprop="image" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/andrzejek.1105365/" class="username " dir="auto" data-user-id="1105365" data-xf-init="member-tooltip"><span itemprop="name">Andrzejek</span></a></h4> <h5 class="userTitle message-userTitle" dir="auto" itemprop="jobTitle">Programmer</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>Jan 10, 2006</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>8,550</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7541729" data-lb-caption-desc="Andrzejek · Jan 25, 2023 at 3:57 PM"> <article class="message-body js-selectToQuote"> <div itemprop="text"> <div class="bbWrapper">This is just my personal opinion, but...<br /> "download a table as a csv from a third party and then save it as an xlsx file"<br /> Depending how you do it, you may run into an issue of <a href="https://www.watershedlrs.com/blog/product/xapi-data-transformation/how-to-open-a-csv-file-in-excel/" target="_blank" class="link link--external" rel="nofollow ugc noopener">Excel 'interpreting' some data</a> NOT the way you would expect or want.<br /> CSV is just a Comma Separated Value <u>text file</u> that can be easily read by VBA and all elements could be easily inserted into your [tt]tblImportTemp[/tt] table, no need for Access' build-in [tt]DoCmd.TransferSpreadsheet[/tt] functionality.<br /> Yes, I know - it is nice to have it ready to use so you don't have to re-invent the wheel, and if it works the way you want - great. But, if it does not, like in your situation, then your own code of transferring the data straight from CSV file into a table, with your full control, sounds like a better solution. <br /> <br /> Just my opinion... <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /><br /> <br /> ---- Andy<br /> <br /> <i>"Hmm...they have the internet on computers now"--Homer Simpson</i></div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="message-microdata" itemprop="interactionStatistic" itemtype="https://schema.org/InteractionCounter" itemscope> <meta itemprop="userInteractionCount" content="0" /> <meta itemprop="interactionType" content="https://schema.org/LikeAction" /> </div> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> <div class="message-cell message-cell--vote"> <div class="message-column"> <div class="contentVote js-contentVote " data-xf-init="content-vote" data-content-id="post-7541729"> <meta itemprop="upvoteCount" content="0" /> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--up " data-vote="up"><span class="u-srOnly">Upvote</span></a> <span class="contentVote-score js-voteCount" data-score="0">0</span> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--down " data-vote="down"><span class="u-srOnly">Downvote</span></a> </div> </div> </div> </div> </article> <article class="message message--post js-post js-inlineModContainer " data-author="JayRo71" data-content="post-7541803" id="js-post-7541803" itemscope itemtype="https://schema.org/Answer" itemid="https://www.tek-tips.com/posts/7541803/"> <meta itemprop="parentItem" itemscope itemid="https://www.tek-tips.com/threads/saved-imoorts-problem-with-file-name.1820222/" /> <span class="u-anchorTarget" id="post-7541803"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541803" rel="nofollow" itemprop="url"> <time class="u-dt" dir="auto" datetime="2023-01-26T14:46:45+0000" data-time="1674744405" data-date-string="Jan 26, 2023" data-time-string="2:46 PM" title="Jan 26, 2023 at 2:46 PM" itemprop="datePublished">Jan 26, 2023</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li class="tag-threadStarter"><span class="message-newIndicator message-threadStarter">Thread starter</span></li> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541803" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7541803/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541803" rel="nofollow"> #10 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" itemprop="author" itemscope itemtype="https://schema.org/Person" itemid="https://www.tek-tips.com/members/jayro71.1692646/"> <meta itemprop="url" content="https://www.tek-tips.com/members/jayro71.1692646/" /> <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/jayro71.1692646/" class="avatar avatar--s" data-user-id="1692646" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="JayRo71" class="avatar-u1692646-s" width="48" height="48" loading="lazy" itemprop="image" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/jayro71.1692646/" class="username " dir="auto" data-user-id="1692646" data-xf-init="member-tooltip"><span itemprop="name">JayRo71</span></a></h4> <h5 class="userTitle message-userTitle" dir="auto" itemprop="jobTitle">Technical User</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>May 13, 2020</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>53</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7541803" data-lb-caption-desc="JayRo71 · Jan 26, 2023 at 2:46 PM"> <article class="message-body js-selectToQuote"> <div itemprop="text"> <div class="bbWrapper">Andy, I have run into a wall and will definitely take your advice. If I can bring the csv into an access table using vba, it would solve a lot of problems. My only concern is that tblImportTemp is the source of an append query. It should not make any difference though. I will report back how I make out. I was able to open the excel table using the article that Dhookum provided to me, but I was only able to get the records to "print" in the immediate window. I was not exactly sure how to pass that along to a table object. The csv import might be easier.</div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="message-microdata" itemprop="interactionStatistic" itemtype="https://schema.org/InteractionCounter" itemscope> <meta itemprop="userInteractionCount" content="0" /> <meta itemprop="interactionType" content="https://schema.org/LikeAction" /> </div> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> <div class="message-cell message-cell--vote"> <div class="message-column"> <div class="contentVote js-contentVote " data-xf-init="content-vote" data-content-id="post-7541803"> <meta itemprop="upvoteCount" content="0" /> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--up " data-vote="up"><span class="u-srOnly">Upvote</span></a> <span class="contentVote-score js-voteCount" data-score="0">0</span> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--down " data-vote="down"><span class="u-srOnly">Downvote</span></a> </div> </div> </div> </div> </article> <article class="message message--post js-post js-inlineModContainer " data-author="Andrzejek" data-content="post-7541806" id="js-post-7541806" itemscope itemtype="https://schema.org/Answer" itemid="https://www.tek-tips.com/posts/7541806/"> <meta itemprop="parentItem" itemscope itemid="https://www.tek-tips.com/threads/saved-imoorts-problem-with-file-name.1820222/" /> <span class="u-anchorTarget" id="post-7541806"></span> <div class="message-header"> <header class="message-attribution message-attribution--split"> <ul class="message-attribution-main listInline "> <li class="u-concealed"> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541806" rel="nofollow" itemprop="url"> <time class="u-dt" dir="auto" datetime="2023-01-26T15:22:17+0000" data-time="1674746537" data-date-string="Jan 26, 2023" data-time-string="3:22 PM" title="Jan 26, 2023 at 3:22 PM" itemprop="datePublished">Jan 26, 2023</time> </a> </li> </ul> <ul class="message-attribution-opposite message-attribution-opposite--list "> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541806" class="message-attribution-gadget" data-xf-init="share-tooltip" data-href="/posts/7541806/share" aria-label="Share" rel="nofollow"> <i class="fa--xf fal fa-share-alt" aria-hidden="true"></i> </a> </li> <li> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/post-7541806" rel="nofollow"> #11 </a> </li> </ul> </header> </div> <div class="message-inner"> <div class="message-cell message-cell--user"> <section class="message-user" itemprop="author" itemscope itemtype="https://schema.org/Person" itemid="https://www.tek-tips.com/members/andrzejek.1105365/"> <meta itemprop="url" content="https://www.tek-tips.com/members/andrzejek.1105365/" /> <div class="message-avatar "> <div class="message-avatar-wrapper"> <a href="/members/andrzejek.1105365/" class="avatar avatar--s" data-user-id="1105365" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="Andrzejek" class="avatar-u1105365-s" width="48" height="48" loading="lazy" itemprop="image" /> </a> </div> </div> <div class="message-userDetails"> <h4 class="message-name"><a href="/members/andrzejek.1105365/" class="username " dir="auto" data-user-id="1105365" data-xf-init="member-tooltip"><span itemprop="name">Andrzejek</span></a></h4> <h5 class="userTitle message-userTitle" dir="auto" itemprop="jobTitle">Programmer</h5> </div> <div class="message-userExtras"> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-calendar fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Joined"></i></dt> <dd>Jan 10, 2006</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-comments fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Messages"></i></dt> <dd>8,550</dd> </dl> <dl class="pairs pairs--justified"> <dt><i class="fa--xf fal fa-map fa-fw" aria-hidden="true" data-xf-init="tooltip" title="Location"></i></dt> <dd> <a href="/misc/location-info?location=US" rel="nofollow noreferrer" target="_blank" class="u-concealed">US</a> </dd> </dl> </div> <span class="message-userArrow"></span> </section> </div> <div class="message-cell message-cell--main"> <div class="message-main js-quickEditTarget"> <div class="message-content js-messageContent"> <div class="message-userContent lbContainer js-lbContainer " data-lb-id="post-7541806" data-lb-caption-desc="Andrzejek · Jan 26, 2023 at 3:22 PM"> <article class="message-body js-selectToQuote"> <div itemprop="text"> <div class="bbWrapper">Let's say this is your [tt]C:\TMP\MyCSVFile.csv[/tt] file with 3 fields (no header):<br /> <br /> [pre]<br /> 123,Bob,987<br /> 234,Bill,345<br /> 345,Susie,765<br /> 456,Andy,463<br /> 567,JayRo,646<br /> 567,TheEnd,987[/pre]<br /> <br /> and you want to insert those records into your Access table named [tt]MyAccessTable[/tt] with 3 fields defined as number, text, and number<br /> <br /> <div class="bbCodeBlock bbCodeBlock--screenLimited bbCodeBlock--code"> <div class="bbCodeBlock-title"> Code: </div> <div class="bbCodeBlock-content" dir="ltr"> <pre class="bbCodeCode" dir="ltr" data-xf-init="code-block" data-lang=""><code>Sub TransferCSVtoTable() Dim strTextLine As String Dim ary() As String Dim strOut As String Dim x As Integer Open [red]"C:\TMP\MyCSVFile.csv"[/red] For Input As #1 Do While Not EOF(1) Line Input #1, strTextLine ary = Split(strTextLine, ",") strOut = "Insert Into MyAccessTable Values (" For x = LBound(ary) To UBound(ary) Select Case x Case 1 strOut = strOut & "'" & ary(x) & "'" [green]'text needs to be in single quotes[/green] Case Else strOut = strOut & ary(x) End Select If x < UBound(ary) Then strOut = strOut & ", " End If Next x strOut = strOut & ")"[blue] Debug.Print strOut[/blue] Loop Close #1 End Sub</code></pre> </div> </div>So you get:[tt]<br /> Insert Into MyAccessTable Values (123, 'Bob', 987)<br /> Insert Into MyAccessTable Values (234, 'Bill', 345)<br /> Insert Into MyAccessTable Values (345, 'Susie', 765)<br /> Insert Into MyAccessTable Values (456, 'Andy', 463)<br /> Insert Into MyAccessTable Values (567, 'JayRo', 646)<br /> Insert Into MyAccessTable Values (567, 'TheEnd', 987)[/tt]<br /> Instead of [blue]Debug.Print[/blue], just [tt]Execute[/tt] these Insert statements in Access.<img src="/data/assets/smilies/wiggle.gif" class="smilie" loading="lazy" alt="[wiggle]" title="[wiggle] [wiggle]" data-shortname="[wiggle]" /><br /> No Excel needed and <u>you</u> are in full control.<br /> <br /> <br /> <br /> ---- Andy<br /> <br /> <i>"Hmm...they have the internet on computers now"--Homer Simpson</i></div> </div> <div class="js-selectToQuoteEnd"> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread2'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread2'); }); </script> </div></div></div> </article> </div> </div> <footer class="message-footer"> <div class="message-microdata" itemprop="interactionStatistic" itemtype="https://schema.org/InteractionCounter" itemscope> <meta itemprop="userInteractionCount" content="0" /> <meta itemprop="interactionType" content="https://schema.org/LikeAction" /> </div> <div class="reactionsBar js-reactionsList "> </div> <div class="js-historyTarget message-historyTarget toggleTarget" data-href="trigger-href"></div> </footer> </div> </div> <div class="message-cell message-cell--vote"> <div class="message-column"> <div class="contentVote js-contentVote " data-xf-init="content-vote" data-content-id="post-7541806"> <meta itemprop="upvoteCount" content="0" /> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--up " data-vote="up"><span class="u-srOnly">Upvote</span></a> <span class="contentVote-score js-voteCount" data-score="0">0</span> <a href="javascript:" class="contentVote-vote is-disabled contentVote-vote--down " data-vote="down"><span class="u-srOnly">Downvote</span></a> </div> </div> </div> </div> </article> </div> </div> <div class="block-outer block-outer--after"> <dl class="blockStatus"> <dt>Status</dt> <dd class="blockStatus-message blockStatus-message--locked"> Not open for further replies. </dd> </dl> </div> </div> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread3'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread3'); }); </script> </div></div></div> <div class="block" data-widget-id="11" data-widget-key="xfes_thread_view_below_quick_reply_similar_threads" data-widget-definition="xfes_similar_threads"> <div class="block-container"> <h3 class="block-header">Similar threads</h3> <div class="block-body"> <div class="structItemContainer"> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1808404" data-author="Anthony343242"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/anthony343242.1697540/" class="avatar avatar--s" data-user-id="1697540" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="Anthony343242" class="avatar-u1697540-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/ms-access-union-all-with-attachment-data-type.1808404/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/ms-access-union-all-with-attachment-data-type.1808404/preview">MS ACCESS UNION ALL with Attachment data type </a> <span class="votesInfo" data-xf-init="tooltip" title="1 member likes this thread!" >1</span> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/anthony343242.1697540/" class="username " dir="auto" data-user-id="1697540" data-xf-init="member-tooltip">Anthony343242</a></li> <li class="structItem-startDate"><a href="/threads/ms-access-union-all-with-attachment-data-type.1808404/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2021-02-04T00:06:03+0000" data-time="1612397163" data-date-string="Feb 4, 2021" data-time-string="12:06 AM" title="Feb 4, 2021 at 12:06 AM">Feb 4, 2021</time></a></li> <li><a href="/forums/microsoft-access-tables-and-relationships.700/">Microsoft: Access Tables and Relationships</a></li> </ul> <span class="structItem-pageJump"> <a href="/threads/ms-access-union-all-with-attachment-data-type.1808404/page-2">2</a> </span> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>29</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>4K</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/ms-access-union-all-with-attachment-data-type.1808404/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2021-02-08T21:28:50+0000" data-time="1612819730" data-date-string="Feb 8, 2021" data-time-string="9:28 PM" title="Feb 8, 2021 at 9:28 PM">Feb 8, 2021</time></a> <div class="structItem-minor"> <a href="/members/anthony343242.1697540/" class="username " dir="auto" data-user-id="1697540" data-xf-init="member-tooltip">Anthony343242</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/anthony343242.1697540/" class="avatar avatar--xxs" data-user-id="1697540" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" alt="Anthony343242" class="avatar-u1697540-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1796808" data-author="Lidias13"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/lidias13.1689048/" class="avatar avatar--s" data-user-id="1689048" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="Lidias13" class="avatar-u1689048-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/odata-contains-fields-from-multiple-tables-in-single-table-with-different-field-names-for-same.1796808/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/odata-contains-fields-from-multiple-tables-in-single-table-with-different-field-names-for-same.1796808/preview">Odata contains fields from multiple tables in single table with different field names - for same</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/lidias13.1689048/" class="username " dir="auto" data-user-id="1689048" data-xf-init="member-tooltip">Lidias13</a></li> <li class="structItem-startDate"><a href="/threads/odata-contains-fields-from-multiple-tables-in-single-table-with-different-field-names-for-same.1796808/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2019-09-05T20:52:03+0100" data-time="1567713123" data-date-string="Sep 5, 2019" data-time-string="8:52 PM" title="Sep 5, 2019 at 8:52 PM">Sep 5, 2019</time></a></li> <li><a href="/forums/microsoft-access-tables-and-relationships.700/">Microsoft: Access Tables and Relationships</a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>1</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>377</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/odata-contains-fields-from-multiple-tables-in-single-table-with-different-field-names-for-same.1796808/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2019-09-06T14:06:58+0100" data-time="1567775218" data-date-string="Sep 6, 2019" data-time-string="2:06 PM" title="Sep 6, 2019 at 2:06 PM">Sep 6, 2019</time></a> <div class="structItem-minor"> <a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip">dhookom</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/dhookom.529593/" class="avatar avatar--xxs" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1794175" data-author="jjMedrano"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/jjmedrano.1687429/" class="avatar avatar--s" data-user-id="1687429" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="jjMedrano" class="avatar-u1687429-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/union-all-with-attachment-data-type.1794175/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/union-all-with-attachment-data-type.1794175/preview">UNION ALL with Attachment data type</a> <span class="votesInfo" data-xf-init="tooltip" title="1 member likes this thread!" >1</span> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/jjmedrano.1687429/" class="username " dir="auto" data-user-id="1687429" data-xf-init="member-tooltip">jjMedrano</a></li> <li class="structItem-startDate"><a href="/threads/union-all-with-attachment-data-type.1794175/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2019-04-16T16:20:09+0100" data-time="1555428009" data-date-string="Apr 16, 2019" data-time-string="4:20 PM" title="Apr 16, 2019 at 4:20 PM">Apr 16, 2019</time></a></li> <li><a href="/forums/microsoft-access-tables-and-relationships.700/">Microsoft: Access Tables and Relationships</a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>8</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>370</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/union-all-with-attachment-data-type.1794175/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2019-04-17T13:52:27+0100" data-time="1555505547" data-date-string="Apr 17, 2019" data-time-string="1:52 PM" title="Apr 17, 2019 at 1:52 PM">Apr 17, 2019</time></a> <div class="structItem-minor"> <a href="/members/andrzejek.1105365/" class="username " dir="auto" data-user-id="1105365" data-xf-init="member-tooltip">Andrzejek</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/andrzejek.1105365/" class="avatar avatar--xxs" data-user-id="1105365" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" alt="Andrzejek" class="avatar-u1105365-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1796260" data-author="BugZap13"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/bugzap13.1653487/" class="avatar avatar--s" data-user-id="1653487" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="BugZap13" class="avatar-u1653487-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/how-to-extract-access-table-schema-with-decimal-places-on-numeric-fields.1796260/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/how-to-extract-access-table-schema-with-decimal-places-on-numeric-fields.1796260/preview">How to extract Access table schema with decimal places on numeric fields?</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/bugzap13.1653487/" class="username " dir="auto" data-user-id="1653487" data-xf-init="member-tooltip">BugZap13</a></li> <li class="structItem-startDate"><a href="/threads/how-to-extract-access-table-schema-with-decimal-places-on-numeric-fields.1796260/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2019-08-05T10:00:43+0100" data-time="1564995643" data-date-string="Aug 5, 2019" data-time-string="10:00 AM" title="Aug 5, 2019 at 10:00 AM">Aug 5, 2019</time></a></li> <li><a href="/forums/microsoft-access-tables-and-relationships.700/">Microsoft: Access Tables and Relationships</a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>2</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>3K</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/how-to-extract-access-table-schema-with-decimal-places-on-numeric-fields.1796260/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2019-08-05T12:04:40+0100" data-time="1565003080" data-date-string="Aug 5, 2019" data-time-string="12:04 PM" title="Aug 5, 2019 at 12:04 PM">Aug 5, 2019</time></a> <div class="structItem-minor"> <a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip">dhookom</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/dhookom.529593/" class="avatar avatar--xxs" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1783158" data-author="puforee"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/puforee.1194207/" class="avatar avatar--s" data-user-id="1194207" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="puforee" class="avatar-u1194207-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/error-when-importing-excel-with-blank-dates.1783158/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/error-when-importing-excel-with-blank-dates.1783158/preview">Error when importing Excel with blank dates</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/puforee.1194207/" class="username " dir="auto" data-user-id="1194207" data-xf-init="member-tooltip">puforee</a></li> <li class="structItem-startDate"><a href="/threads/error-when-importing-excel-with-blank-dates.1783158/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2017-12-20T14:03:17+0000" data-time="1513778597" data-date-string="Dec 20, 2017" data-time-string="2:03 PM" title="Dec 20, 2017 at 2:03 PM">Dec 20, 2017</time></a></li> <li><a href="/forums/microsoft-access-tables-and-relationships.700/">Microsoft: Access Tables and Relationships</a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>4</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>295</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/error-when-importing-excel-with-blank-dates.1783158/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2017-12-21T12:05:11+0000" data-time="1513857911" data-date-string="Dec 21, 2017" data-time-string="12:05 PM" title="Dec 21, 2017 at 12:05 PM">Dec 21, 2017</time></a> <div class="structItem-minor"> <a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip">dhookom</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/dhookom.529593/" class="avatar avatar--xxs" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> </div> </div> </div> </div> <div class="blockMessage blockMessage--none"> <div class="shareButtons shareButtons--iconic" data-xf-init="share-buttons" data-page-url="" data-page-title="" data-page-desc="" data-page-image=""> <span class="shareButtons-label">Share:</span> <div class="shareButtons-buttons"> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--facebook" data-href="https://www.facebook.com/sharer.php?u={url}"> <i aria-hidden="true"></i> <span>Facebook</span> </a> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--twitter" data-href="https://twitter.com/intent/tweet?url={url}&text={title}"> <svg xmlns="http://www.w3.org/2000/svg" height="1em" viewBox="0 0 512 512" class=""><path d="M389.2 48h70.6L305.6 224.2 487 464H345L233.7 318.6 106.5 464H35.8L200.7 275.5 26.8 48H172.4L272.9 180.9 389.2 48zM364.4 421.8h39.1L151.1 88h-42L364.4 421.8z"/></svg> <span>X (Twitter)</span> </a> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--reddit" data-href="https://reddit.com/submit?url={url}&title={title}"> <i aria-hidden="true"></i> <span>Reddit</span> </a> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--pinterest" data-href="https://pinterest.com/pin/create/bookmarklet/?url={url}&description={title}&media={image}"> <i aria-hidden="true"></i> <span>Pinterest</span> </a> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--tumblr" data-href="https://www.tumblr.com/widgets/share/tool?canonicalUrl={url}&title={title}"> <i aria-hidden="true"></i> <span>Tumblr</span> </a> <a class="shareButtons-button shareButtons-button--brand shareButtons-button--whatsApp" data-href="https://api.whatsapp.com/send?text={title} {url}"> <i aria-hidden="true"></i> <span>WhatsApp</span> </a> <a class="shareButtons-button shareButtons-button--email" data-href="mailto:?subject={title}&body={url}"> <i aria-hidden="true"></i> <span>Email</span> </a> <a class="shareButtons-button shareButtons-button--share is-hidden" data-xf-init="web-share" data-title="" data-text="" data-url="" data-hide=".shareButtons-button:not(.shareButtons-button--share)"> <i aria-hidden="true"></i> <span>Share</span> </a> <a class="shareButtons-button shareButtons-button--link is-hidden" data-clipboard="{url}"> <i aria-hidden="true"></i> <span>Link</span> </a> </div> </div> </div> </div> </div> <div class="p-sidebarWrapper"> <div class="p-body-sidebar"> <div class="block block--login"> <form action="/login/login" method="post" class="" > <input type="hidden" name="_xfToken" value="1739910383,2cf68ef154384486935033873e1cc858" /> <div class="block-container"> <h3 class="block-minorHeader"> Log in </h3> <div class="block-body"> <div class="block-row"> <dl class="formRow formRow--input"> <dt> <div class="formRow-labelWrapper"> <label class="formRow-label" for="_xfUid-1-1739910383">Your name or email address</label></div> </dt> <dd> <input type="text" class="input" name="login" autocomplete="username" id="_xfUid-1-1739910383" /> </dd> </dl> <dl class="formRow formRow--input"> <dt> <div class="formRow-labelWrapper"> <label class="formRow-label" for="_xfUid-2-1739910383">Password</label></div> </dt> <dd> <input type="password" class="input" name="password" autocomplete="current-password" id="_xfUid-2-1739910383" /> <a href="/lost-password/" data-xf-click="overlay">Forgot your password?</a> </dd> </dl> <dl class="formRow"> <dt> <div class="formRow-labelWrapper"></div> </dt> <dd> <ul class="inputChoices"> <li class="inputChoices-choice"><label class="iconic"><input type="checkbox" name="remember" value="1" checked="checked" /><i aria-hidden="true"></i><span class="iconic-label">Stay logged in</span></label></li> </ul> </dd> </dl> <dl class="formRow formSubmitRow"> <dt></dt> <dd> <div class="formSubmitRow-main"> <div class="formSubmitRow-bar"></div> <div class="formSubmitRow-controls"><button type="submit" class="button--primary button button--icon button--icon--login"><span class="button-text">Log in</span></button></div> </div> </dd> </dl> <dl class="formRow formRegisterRow"> <dt></dt> <dd>Don't have an account? <a href="/register/" data-xf-click="overlay" data-follow-redirects="on">Register now</a></dd> </dl> </div> </div> </div> </form> </div> <div class="block"> <div class="block-container" data-widget-id="18" data-widget-key="right_search_top" data-widget-definition="html"> <h3 class="block-minorHeader">Part and Inventory Search</h3> <div class="block-body block-row"> <center><div id='div-gpt-tektips_customsearchbox'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_customsearchbox'); }); </script> </div> </center> </div> </div> </div> <div class="block"> <div class="block-container" data-widget-id="13" data-widget-key="right_rail_middle_bottom_ga" data-widget-definition="html"> <h3 class="block-minorHeader">Sponsor</h3> <div class="block-body block-row"> <center> <div id='div-gpt-tektips_sidebar1'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_sidebar1'); }); </script> </div> </center> </div> </div> </div> <div class="block"> <div class="block-container" data-widget-id="21" data-widget-key="sidebar_bottom_ad" data-widget-definition="html"> <div class="block-body block-row"> <center> <div id='div-gpt-tektips_sidebarbottom'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_sidebarbottom'); }); </script> </div> </center> </div> </div> </div> </div> </div> </div> <div class="p-breadcrumbs--parent p-breadcrumbs--bottom"> <ul class="p-breadcrumbs p-breadcrumbs--bottom" itemscope itemtype="https://schema.org/BreadcrumbList"> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="https://www.tek-tips.com" itemprop="item"> <span itemprop="name">Home</span> </a> <meta itemprop="position" content="1" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/" itemprop="item"> <span itemprop="name">Forums</span> </a> <meta itemprop="position" content="2" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/#software.1001" itemprop="item"> <span itemprop="name">Software</span> </a> <meta itemprop="position" content="3" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/categories/programmers.1004/" itemprop="item"> <span itemprop="name">Programmers</span> </a> <meta itemprop="position" content="4" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/categories/dbms-packages.10027/" itemprop="item"> <span itemprop="name">DBMS Packages</span> </a> <meta itemprop="position" content="5" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/forums/microsoft-access-tables-and-relationships.700/" itemprop="item"> <span itemprop="name">Microsoft: Access Tables and Relationships</span> </a> <meta itemprop="position" content="6" /> </li> </ul> </div> </div> </div> </div>  <footer class="p-footer" id="footer"> <div class="p-footer--container footer-stretched"> <div class="p-footer-default"> <div class="p-footer-inner"> <div class="p-footer-row"> <div class="p-footer-row-main"> <ul class="p-footer-linkList"> <li class="p-linkList-changeStyle"><a href="/misc/style" data-xf-click="overlay" data-xf-init="tooltip" title="Style: TekTips" rel="nofollow"> Style chooser </a></li> <li class="p-linkList-changeWidth"><a class="pageWidthToggle xb-toggle-default" role="button" tabindex="0" data-xf-click="toggle" data-target="html" data-active-class="xb-toggle-default" data-xf-init="toggle-storage" data-storage-type="cookie" data-storage-expiry="31556926" data-storage-key="_xb-width"> Change width </a></li> </ul> </div> <div class="p-footer-row-opposite"> <ul class="p-footer-linkList"> <li><a href="/misc/contact" data-xf-click="overlay">Contact us</a></li> <li><a href="/help/terms/">Terms and rules</a></li> <li><a href="/help/privacy-policy/">Privacy policy</a></li> <li><a href="/help/">Help</a></li> <li><a href="https://www.tek-tips.com">Home</a></li> <li><a href="/forums/-/index.rss" target="_blank" class="p-footer-rssLink" title="RSS"><span aria-hidden="true"><i class="fa--xf fal fa-rss" aria-hidden="true"></i><span class="u-srOnly">RSS</span></span></a></li> </ul> </div> </div> </div> </div> <div class="p-footer-copyright"> <div class="p-footer-inner"> <div class="p-footer-copyright--flex"> <div class="copyright-left"> Copyright © <script type="text/javascript">d = new Date();y = d.getFullYear();document.write(y);</script> WTWH Media, LLC. All Rights Reserved. </div> </div> </div> </div> </div> </footer> </div>  </div>  <div class="u-bottomFixer js-bottomFixTarget"> <ul class="notices notices--bottom_fixer js-notices" data-xf-init="notices" data-type="bottom_fixer" data-scroll-interval="6"> <li class="notice js-notice notice--primary notice--cookie" data-notice-id="-1" data-delay-duration="0" data-display-duration="0" data-auto-dismiss="0" data-visibility=""> <div class="notice-content"> <div class="u-alignCenter"> This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.<br /> By continuing to use this site, you are consenting to our use of cookies. </div> <div class="u-inputSpacer u-alignCenter"> <a href="/account/dismiss-notice" class="js-noticeDismiss button--notice button button--icon button--icon--confirm"><span class="button-text">Accept</span></a> <a href="/help/cookies" class="button--notice button"><span class="button-text">Learn more…</span></a> </div> </div> </li> </ul> </div> <div class="u-navButtons js-navButtons" data-trigger-type="up"> <a href="javascript:" class="button--scroll button"><span class="button-text"><i class="fa--xf fal fa-arrow-left" aria-hidden="true"></i><span class="u-srOnly">Back</span></span></a> </div> <div class="u-scrollButtons js-scrollButtons" data-trigger-type="up"> <a href="#top" class="button--scroll button" data-xf-click="scroll-to"><span class="button-text"><i class="fa--xf fal fa-arrow-up" aria-hidden="true"></i><span class="u-srOnly">Top</span></span></a> </div> <script src="/js/vendor/jquery/jquery-3.5.1.min.js?_v=40da5a00"></script> <script src="/js/vendor/vendor-compiled.js?_v=40da5a00"></script> <script src="/js/xf/core-compiled.js?_v=40da5a00"></script> <script src="/js/xf/code_block-compiled.js?_v=40da5a00"></script> <script src="/js/sv/ese/xf/structure.min.js?_v=40da5a00"></script> <script src="/js/xf/notice.min.js?_v=40da5a00"></script> <script> $(".xb-searchWrapper").on("click", function(event) { $(".xb-searchWrapper").addClass("is-active"); event.stopPropagation(); }); $(".xb-searchWrapper").on("click", function(event) { event.stopPropagation(); }); $(document).on("click", function(event) { $(".xb-searchWrapper").removeClass("is-active"); }); </script> <script> jQuery.extend(true, XF.config, { // userId: 0, enablePush: false, pushAppServerKey: '', url: { fullBase: 'https://www.tek-tips.com/', basePath: '/', css: '/css.php?css=__SENTINEL__&s=3&l=1&d=1735569278', keepAlive: '/login/keep-alive' }, cookie: { path: '/', domain: '', prefix: 'xf_', secure: true, consentMode: 'simple', consented: ["optional","_third_party"] }, cacheKey: 'b39cae7ab74ce674f2496a078a6e6a89', csrf: '1739910383,2cf68ef154384486935033873e1cc858', js: {"\/js\/xf\/code_block-compiled.js?_v=40da5a00":true,"\/js\/sv\/ese\/xf\/structure.min.js?_v=40da5a00":true,"\/js\/xf\/notice.min.js?_v=40da5a00":true}, css: {"public:bb_code.less":true,"public:message.less":true,"public:notices.less":true,"public:share_controls.less":true,"public:snog_groups.less":true,"public:structured_list.less":true,"public:svESE_autocomplete.less":true,"public:xb.less":true,"public:xb_search.less":true,"public:xb_sidebar_login.less":true,"public:xb_welcome.less":true,"public:xc_soft_attachment.less":true,"public:xc_votes_button.less":true,"public:extra.less":true}, time: { now: 1739910383, today: 1739836800, todayDow: 2, tomorrow: 1739923200, yesterday: 1739750400, week: 1739318400 }, borderSizeFeature: '2px', fontAwesomeWeight: 'l', enableRtnProtect: true, enableFormSubmitSticky: true, uploadMaxFilesize: 268435456, allowedVideoExtensions: ["m4v","mov","mp4","mp4v","mpeg","mpg","ogv","webm"], allowedAudioExtensions: ["mp3","opus","ogg","wav"], shortcodeToEmoji: true, visitorCounts: { conversations_unread: '0', alerts_unviewed: '0', total_unread: '0', title_count: true, icon_indicator: true }, jsState: {}, publicMetadataLogoUrl: '', publicPushBadgeUrl: 'https://www.tek-tips.com/styles/default/xenforo/bell.png' }); jQuery.extend(XF.phrases, { // date_x_at_time_y: "{date} at {time}", day_x_at_time_y: "{day} at {time}", yesterday_at_x: "Yesterday at {time}", x_minutes_ago: "{minutes} minutes ago", one_minute_ago: "1 minute ago", a_moment_ago: "A moment ago", today_at_x: "Today at {time}", in_a_moment: "In a moment", in_a_minute: "In a minute", in_x_minutes: "In {minutes} minutes", later_today_at_x: "Later today at {time}", tomorrow_at_x: "Tomorrow at {time}", day0: "Sunday", day1: "Monday", day2: "Tuesday", day3: "Wednesday", day4: "Thursday", day5: "Friday", day6: "Saturday", dayShort0: "Sun", dayShort1: "Mon", dayShort2: "Tue", dayShort3: "Wed", dayShort4: "Thu", dayShort5: "Fri", dayShort6: "Sat", month0: "January", month1: "February", month2: "March", month3: "April", month4: "May", month5: "June", month6: "July", month7: "August", month8: "September", month9: "October", month10: "November", month11: "December", active_user_changed_reload_page: "The active user has changed. Reload the page for the latest version.", server_did_not_respond_in_time_try_again: "The server did not respond in time. Please try again.", oops_we_ran_into_some_problems: "Oops! We ran into some problems.", oops_we_ran_into_some_problems_more_details_console: "Oops! We ran into some problems. Please try again later. More error details may be in the browser console.", file_too_large_to_upload: "The file is too large to be uploaded.", uploaded_file_is_too_large_for_server_to_process: "The uploaded file is too large for the server to process.", files_being_uploaded_are_you_sure: "Files are still being uploaded. Are you sure you want to submit this form?", attach: "Attach files", rich_text_box: "Rich text box", close: "Close", link_copied_to_clipboard: "Link copied to clipboard.", text_copied_to_clipboard: "Text copied to clipboard.", loading: "Loading…", you_have_exceeded_maximum_number_of_selectable_items: "You have exceeded the maximum number of selectable items.", processing: "Processing", 'processing...': "Processing…", showing_x_of_y_items: "Showing {count} of {total} items", showing_all_items: "Showing all items", no_items_to_display: "No items to display", number_button_up: "Increase", number_button_down: "Decrease", push_enable_notification_title: "Push notifications enabled successfully at Tek-Tips", push_enable_notification_body: "Thank you for enabling push notifications!", pull_down_to_refresh: "Pull down to refresh", release_to_refresh: "Release to refresh", refreshing: "Refreshing…" , "svStandardLib_time.day": "{count} day", "svStandardLib_time.days": "{count} days", "svStandardLib_time.hour": "{count} hour", "svStandardLib_time.hours": "{count} hours", "svStandardLib_time.minute": "{count} minutes", "svStandardLib_time.minutes": "{count} minutes", "svStandardLib_time.month": "{count} month", "svStandardLib_time.months": "{count} months", "svStandardLib_time.second": "{count} second", "svStandardLib_time.seconds": "{count} seconds", "svStandardLib_time.week": "time.week", "svStandardLib_time.weeks": "{count} weeks", "svStandardLib_time.year": "{count} year", "svStandardLib_time.years": "{count} years" }); </script> <form style="display:none" hidden="hidden"> <input type="text" name="_xfClientLoadTime" value="" id="_xfClientLoadTime" title="_xfClientLoadTime" tabindex="-1" /> </form>  <script type="application/ld+json"> { "@context": "https://schema.org", "@type": "QAPage", "url": "https://www.tek-tips.com/threads/saved-imoorts-problem-with-file-name.1820222/", "mainEntity": { "@type": "Question", "@id": "https://www.tek-tips.com/threads/saved-imoorts-problem-with-file-name.1820222/", "name": "Saved Imoorts problem with file name", "datePublished": "2023-01-25T12:28:26+00:00", "url": "https://www.tek-tips.com/threads/saved-imoorts-problem-with-file-name.1820222/", "text": "Hi,\n\nMy work flow is to download a table as a csv from a third party and then save it as an xlsx file. I give it a new filename when I do a saveas xlsx, because the default filename from the third party has special characters in it that are not compatible with access import. \n\nThe import works perfectly and I save the steps as a saved import. I can run this saved import over and over again, with no problems at all. That is, until I download a new csv file from the third party and overwrite the previous xlsx file. For some reason, the saved import, now sees the default file name and disregards the saveas name. Consequently, it lists the original filename from the third party as an invalid file name and halts the import. \n\nThe main reason I want to use a saved import is because I have a field that I need to change to short text instead of a number each time I do the import. Saved import would automate this process. \n\nI believe that somehow, the excel file logs the original filename somewhere as a constant and it is where Access looks up the filename in its saved import procedure.\n\nSome things I will try. \n\nInstead of overwriting the first xlsx file using excel saveas, I will delete the original file before doing the saveas, so I will not be overwriting an existing file. \nI will also try renaming the file in the directory tree, rather than renaming it with a saveas. \n\nAny other ideas as to what is going on or a work around would be helpful. \n\nThanks.", "answerCount": 10, "upvoteCount": 0, "author": { "@type": "Person", "@id": "https://www.tek-tips.com/members/jayro71.1692646/", "name": "JayRo71", "url": "https://www.tek-tips.com/members/jayro71.1692646/" }, "suggestedAnswer": [ { "@type": "Answer", "datePublished": "2023-01-26T15:22:17+00:00", "url": "https://www.tek-tips.com/posts/7541806/", "text": "Let's say this is your C:\\TMP\\MyCSVFile.csv file with 3 fields (no header):\n\n\n123,Bob,987\n234,Bill,345\n345,Susie,765\n456,Andy,463\n567,JayRo,646\n567,TheEnd,987\n\nand you want to insert those records into your Access table named MyAccessTable with 3 fields defined as number, text, and number\n\n\nSub TransferCSVtoTable()\nDim strTextLine As String\nDim ary() As String\nDim strOut As String\nDim x As Integer\n\nOpen \"C:\\TMP\\MyCSVFile.csv\" For Input As #1\nDo While Not EOF(1)\n Line Input #1, strTextLine\n ary = Split(strTextLine, \",\")\n strOut = \"Insert Into MyAccessTable Values (\"\n For x = LBound(ary) To UBound(ary)\n Select Case x\n Case 1\n strOut = strOut & \"'\" & ary(x) & \"'\" 'text needs to be in single quotes\n Case Else\n strOut = strOut & ary(x)\n End Select\n If x < UBound(ary) Then\n strOut = strOut & \", \"\n End If\n Next x\n strOut = strOut & \")\"\n Debug.Print strOut\nLoop\nClose #1\nEnd Sub\n\nSo you get:\nInsert Into MyAccessTable Values (123, 'Bob', 987)\nInsert Into MyAccessTable Values (234, 'Bill', 345)\nInsert Into MyAccessTable Values (345, 'Susie', 765)\nInsert Into MyAccessTable Values (456, 'Andy', 463)\nInsert Into MyAccessTable Values (567, 'JayRo', 646)\nInsert Into MyAccessTable Values (567, 'TheEnd', 987)\nInstead of Debug.Print, just Execute these Insert statements in Access.[wiggle]\nNo Excel needed and you are in full control.\n\n\n\n---- Andy\n\n\"Hmm...they have the internet on computers now\"--Homer Simpson", "upvoteCount": 0, "author": { "@type": "Person", "@id": "https://www.tek-tips.com/members/andrzejek.1105365/", "name": "Andrzejek", "url": "https://www.tek-tips.com/members/andrzejek.1105365/" } }, { "@type": "Answer", "datePublished": "2023-01-26T14:46:45+00:00", "url": "https://www.tek-tips.com/posts/7541803/", "text": "Andy, I have run into a wall and will definitely take your advice. If I can bring the csv into an access table using vba, it would solve a lot of problems. My only concern is that tblImportTemp is the source of an append query. It should not make any difference though. I will report back how I make out. I was able to open the excel table using the article that Dhookum provided to me, but I was only able to get the records to \"print\" in the immediate window. I was not exactly sure how to pass that along to a table object. The csv import might be easier.", "upvoteCount": 0, "author": { "@type": "Person", "@id": "https://www.tek-tips.com/members/jayro71.1692646/", "name": "JayRo71", "url": "https://www.tek-tips.com/members/jayro71.1692646/" } }, { "@type": "Answer", "datePublished": "2023-01-25T15:57:33+00:00", "url": "https://www.tek-tips.com/posts/7541729/", "text": "This is just my personal opinion, but...\n\"download a table as a csv from a third party and then save it as an xlsx file\"\nDepending how you do it, you may run into an issue of Excel 'interpreting' some data NOT the way you would expect or want.\nCSV is just a Comma Separated Value text file that can be easily read by VBA and all elements could be easily inserted into your tblImportTemp table, no need for Access' build-in DoCmd.TransferSpreadsheet functionality.\nYes, I know - it is nice to have it ready to use so you don't have to re-invent the wheel, and if it works the way you want - great. But, if it does not, like in your situation, then your own code of transferring the data straight from CSV file into a table, with your full control, sounds like a better solution. \n\nJust my opinion... :-)\n\n---- Andy\n\n\"Hmm...they have the internet on computers now\"--Homer Simpson", "upvoteCount": 0, "author": { "@type": "Person", "@id": "https://www.tek-tips.com/members/andrzejek.1105365/", "name": "Andrzejek", "url": "https://www.tek-tips.com/members/andrzejek.1105365/" } } ] }, "publisher": { "@type": "Organization", "name": "Tek-Tips", "alternateName": "Tek-Tips Information Technology Professional Forums", "description": "Tek-Tips Forums is an intelligent work forum community for Information Technology professionals.", "url": "https://www.tek-tips.com" } } </script> </body> </html>

CINXE.COM

Saved Imoorts problem with file name - Microsoft: Access Tables and Relationships | Tek-Tips