I am trying to upload a file to Access DB, however the destination file has more columns than the file being uploaded. Not sure how to accomplish this.
[z{email redacted per site policy}]
9 1681 zmbd 5,501
Expert Mod 4TB
Sherianmartin:
A little more detail would be helpful:
Access Version;
Source file format;
What have you tried so far;
etc?
Also please see our FAQ on asking questions. As a general rule, all questions should be answered here in the public forums and not via PM or third-party emails.
I am using Access 2010. The file I'm uploading is Excel 2010. I am trying to overwrite or append an existing file in access with the new excel file. However, the access file has a lot more columns than the excel file. I don't want to recreate the access file. I might be able to use an append query, but I'm not sure how that works. Thanks.
Sherianmartin,
You can link the Excel file to your DB (External Data, then Excel), and then the DB will treat the Excel worksheet as a Table.
To build an append query, go to Create, Query Design, select the linked Spreadsheet, then under Query Tools, select Append Query. Choose which field in the Excel Spreadsheet corresponds to the field in the Table.
Let us know if you need additional assistance.
What I really want is one table with all the fields. The Access file has all the fields, however the excel file doesn't, however it has the current information that I need. I will receive an excel file every month and I would like this process to be automated as much as possible. thanks.
zmbd 5,501
Expert Mod 4TB
Easy enough, copy your XL.File and name it, "importme.xlxs" (the name doesn't matter). Now do as TwinnyFo has said, link to the file, create an append query and run it.
Next month, receive your file, save over your old XL.File as importme.xlxs in the same location, and run your append query.
There are ways to automate the copy/renaming of the XL.file and running the append query via VBA script; however, that would require a new thread. (^_^)
Does anyone know why date fields come over as text when they are uploaded from Excel to Access? Just had this happen to a file I'm working with. Any suggestions?
Hi, I am trying to change the datatype in Access from Text to Date/Time. However, I keep getting an error message "Not enough disk space or memory". Not sure why or how I can fix this. Thanks.
Concerning Post #7, the values in your Spreadsheet are probably saved as Text, rather than as Dates. You can perform a conversion at runtime, such as:
As long as the date field "looks" like a date, it should convert it into an actual date.
Not sure why you would be getting the error in Post #8.....
zmbd 5,501
Expert Mod 4TB
--- It appears that the original question has been answered
Briefly, because this might happen to others that are also importing data, on cause to Post#8's memory issue is an annoyance in ACC2010 that was introduced in ACC2000. In earlier versions, at least it didn't cause the memory error. Failures caused by Name AutoCorrect - Allen Browne
Close your database and re-open is the usual short term fix. I will follow the above link's advice on every new database I create due to the issues.
The other possible root cause is that the PC physically doesn't have enough RAM to handle the data conversion.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: rbt |
last post by:
Has anyone used pure python to upload files to a webdav server over SSL?
I have no control over the server. I can access it with all of the
various webdav GUIs such as Konqueror, Cadaver, etc. by...
|
by: Dave Navarro |
last post by:
I am using some free Upload code by Jacob Gilley:
''***************************************
'' File: Upload.asp
'' Author: Jacob "Beezle" Gilley
'' Email: avis7@airmail.net
'' Date: ...
|
by: ayanwen |
last post by:
I have problem in uploading files using ASP, can you give me some sample
code about uploading using ASP?
--
ayanwen
------------------------------------------------------------------------...
|
by: Dean Richardson |
last post by:
Hi,
I'm having trouble uploading files via a PHP script. Whenever I upload
a file greater than 10K, the file gets corrupted. However, text files
upload OK.
When I check the FTP Server log I...
|
by: Milsnips |
last post by:
Hi there,
this is my situation:
i have a webpage with a photo gallery, when i am uploading files sometimes
it takes a while, and when i open another browser window to view the photo
gallery...
|
by: mivey4 |
last post by:
I have been experimenting with sending and receiving files using the webClient class provided in .NET. (C#)
I don't seem to have any problems downloading files from my test web server using the...
|
by: =?ISO-8859-1?Q?=22=C1lvaro_G=2E_Vicario=22?= |
last post by:
jodleren escribió:
I haven't found the PHP manual page where such feature is documented but
a few tests have shown that this behaviour changes depending on the
charset parameter of the...
|
by: Gabriel Pineda |
last post by:
hi, i'm having a problem that is driving me nut!
i have an asp.net application runnning in a server.
the application allows to uploading files.
from my computer i can upload files without any...
|
by: LoriFranklin |
last post by:
I'm a bit of a newbie here. I've learned a lot from reading the posts you all have here. I need some help uploading files using an asp form.
I am using some code that I found from Jacob at...
|
by: rian92 |
last post by:
Hi,
I followed the instructions in the thread Uploading files into MySQL database using php and this code just work fine.
But after I add few new data it got a problem. Hope you can help me....
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |