I have a vba code that builds a SQL String, opens a connection to SQL server and imports the contents of a SQL View into an Access table. Everything works fine, except one column "primary_account" where I store 1 and 0 for True and False. In Access 1 shows up as -1.
View RepliesWe are in the process of converting from dBase to Access. We have successfully imported one of our data files into Access. When we go in and try to change the field sizes we keep getting an error that there is not enough disk space or memory. Is there a general rule when doing this? We have tried decreasing the amount of records and continue to get the error. When we originally imported the file we did not set a field size limitation so all the text fields in the structure came in at a size of 255. We are trying to change them to their proper size.
If a database is 20MB how much memory or space is required to make changes such as this? The original file contains over 300,000 records.
Any help or direction would be greatly appreciated.
Heather
I have impotred a table of my MP3 music collection from Excel in to Access.
The Fields it contains are: "Artist" - "Album" - "Track Name" - "Track No." - & "Duration"
I would like an option to be able to list only the Artist & Albums - However, when I try I end up with a list of duplicate values for the Album field (as these relate to track 1, track 2, track , etc...)
I'm sure there's a simple solution..
Can anyone please help....
Thanks,
Alun Kane
Hi,
I have a table in Excel, and when I import the table in Access, some records from a specific field shows #Num! after importing, even before I imported the table, I selected the entire field in Excel and I Formated all cells to text.
The specific field hosts records in digit format[34222256], and sometime in mixed letter-digit format[M22228778], but are supposed to be as TEXT! After importing I see the first as #Num!, and the second as M22228778.
How can I get around this issue in Excel or Access.
Thank you!
Hi, i have a fox pro memo field that has bill of materials information in like so:EACH KIT COMPRISES
1 CR10070SW £29.60 HALLITE PRODUCT
1 RBS24690 £0.82
1 RBS354 £0.95
2 RBS345 £0.75
1 S95MMEXT £3.90
£36.77 PER KIT
I need to take out the carriage returns but keep the items delimited in some way so they all apear on the one line. These are the child parts for kits so i need to keep them on one line as i import them or via a query so i can see the parent part they belong to.
Many Thanks
I have imported a worksheet from excel.
I am trying to use query criteria to seach.
the feild I am trying to search was a custom 000-000-000 cell.
I have been trying to use like "001*" but am getting nothing back.
what should I do. Do I need to change the info in excel and start over?
thanks
I am new to Access and I think there is a simple answer to this question, but I am lost.
I have several access databases that are the same, i.e forms,tables, but have different data in the tables.
I created a query in one and was planning to import into all the others. However, after importing the query to another database it did not run, i.e I could see the field names but no data showed. The field names and tables are the same in the import database as the export one. However, neither database has relationship, joins(relationships) are created within the query.
Can anyone please tell me why this query will not run when imported, I would hate to recreate it for every database I have to work with for this project.
Thank you
I uploaded quite a bit of data from an extensive list of Word Documents. In some of the Memo fields, it imported these weird Squares. Some times at Tabs or Paragraph returns.Is there an Easy way to remove these things?
View 1 Replies View RelatedMy "MainMenuForm" contains a button that imports a specific csv on a specific location.Someone should do this import once per day. The problem is that there is no way for me, once the import has been done, to know which records are "new".There is no unique field that distinguishes the new records from the old ones.
I was thinking of adding like a Date() field to that csv (= the date where it was imported). Can this be done automatically? So if I import a file today, the final column would be 05/02/2015If i import a new file tomorrow, it would be 06/02/2015.
Hi
I have imported data from Outlook. The field I am interested in is the
'Subject' Field. This contains 3 effective segments,
1 employee name
2 description
3 job and sub job number
example of text in field is
M.Heywood Completed Job No.1708 8
N.Curry Completed Job No.1477
I wish to move the employee name into another field and also the job and sub
job number. I have tried the following Right() Function but it is not quite
working as I want
Right$([Subject],InStr([Subject],"Completed Job No.")-1)
For the records above the results are as follows
No.1708 8
No.1477
What I really want is to only get the text after the .
Any help please as this is my first time with this function
Thanks
Richard
Hello there,
In Table A I have a field called Pin Number.
I set an input mask for this field, Pin Number.
Now I have imported a huge number of records into Table B from Excel which also contains Pin Numbers.
I need to link all fields with Pin Numbers, so my question is:
How can I change newly imported data fields to conform to a previous input mask?
many huge thanks, :)
Hi,
Does anyone know how I can get the imported table PATHS in VB code and current database path?
Thanx :confused:
I have an imported table that I created a form for (containing 400+ entries). I created a subform on it for a new table that I will be entering information to tie in with the imported form.
However, when I try to create a report, the report won't acknowledge any of the information. It's all outlined in the SQL, but nothing appears.
I did discover, though, that if I create a new entry on the imported table, that information appears on the report, but nothing for the existing data that was imported.
Please help!!!!!
I am importing about 1.5 million records from a .txt file into an Access database. I have the code that splits the records and adds them to the database. However, the database has a 'specialty' table that lists certain specialty codes. The incoming record has a field that is a specialty code. Any way to search the 'specialty' table for the code that is coming in on the record to be added, and then, if the record 'code' is not found, skip it, and if it is found, add it to the database. There are about 70 codes in the 'specialty' table.
View 9 Replies View RelatedI need to import a text file into access 10, the problem is as i understand it access has a db limit of 255 columns.
The text file is delimited by | symbols. As i tried to import, it shows me to have 267 columns and all the columns are unique and needs to be used for my work.
Am trying to import data into a blank database (MS access 2013). The import operation is successful. But the data in the tables gets deleted after a while. And all I can see are blank tables in Access 2013.
View 2 Replies View RelatedI am Extracting that data into an excel document from the fillable PDF and importing into Access.... NOW. Here is what I am trying to figure out. I have to alert the field of major changes, SO I am wanting Access to compare the document I imported last with the one I imported just now. Example. I change my contact information, I need a query to find that the information I submitted last time, is not the same as what I just submitted. My issue is, I cannot get a vision for this database. I can import these documents to a table BUT I cannot compare these line items with line items of the same table...
View 3 Replies View RelatedHello, Could someone advise me how to fix this little problem i have when importing a spreadsheet. My app outputs two columns into a spreadsheet with the following US date formats.The spreadsheet it generates is called dates.xls, and i need to re-arrange all the dates in the spreadsheet to a British date format dd/mm/yyyy and re-save it as dates.xls from a click of a button on my form.I know i can use text to columns in excel to fix this problem, but i want access to do it for me, preferbly in VBA, as in the future i may be working with multiple columns. Thankyou for any suggestions.20070612 2007011220070529 2007031920070530 2007040620070530 2007040620070530 2007040620070530 2007040620070530 2007040620070518 2007040620070525 2007041520070521 2007041920070608 20070430
View 2 Replies View RelatedI am using DoCmd.TransferText to import a CSV file to a new table.
The problem is some of the fields contain quotation marks which really messes things up for me later on.
Is there some way I can go through the whole table and remove them?
Maybe a Query?
Or VBA?
I have imported an Excel spreadsheet into an Access database. In Excel, a line break in a cell is entered by ALT+Enter. After importing my spreadsheet, all my line breaks appear as "□" and the text all runs together (no line breaks) in the table. The "□"s are also printed in reports. I need a way to either (1) make the "□"s appear as line breaks (e.g., by changing some Access property) or to convert the "□"s to something that shows as a line break in an the Access table memo field (e.g., CNTRL+Enter). Can anyone tell me how to make this happen?
I've tried to copy/paste the "□" into the Find/Replace dialog, but nothing appears when I paste. I understand the memo field is unicode, but I have not been able to determine what the "□" character actually is. It is not the same as the only similar squared shaped character I find in the Arial character map (U+25A1: White Square). I can copy and paste the "□", if surrounded by some other text, e.g., "xxx□yyy", into a Notepad document and it shows up as "xxx□yyy". Pasting the same into a Word doc and I get
"xxx
yyy" with the line break properly displayed. I can copy and paste just the □ itself in Notepad.
Hi
I have a table that I am importing from FOXPRO DATABASE. When someone goes into the system and deletes a record, Foxpro does not really delete the records but marks it for deletion. There is no field to query on that I can see in the table, but when I go to Foxpro the record is "marked" for deletion.
Anyway to exclude these records when doing a query or importing the table?
Thanks
I am trying to find a way to have a date and time stamp applied to records that I am importing from excel. I have not had much luck, and woudl appreciate any help.
View 4 Replies View RelatedI am using Access 2002.I am going to be producing a macro that imports a txt file. Once the text file is imported there will be a empty field for a date value. Nothing in the file that is being imported will have a date in it.
I would like to (if possible) to, once the file is in the table, open an input box asking the user for a date (formated as YYYY-MM-DD) and once the date has been entered and the ok button pressed it inputs that date in to all records in the date field.
I am having an issue with an Access import. It worked correctly bringing in a sharepoint spreadsheet until a date field was added to the spreadsheet and the structure to the database. Now it drops any additional fields that are added. At first I thought if I added a filler field after the field I needed that it would still drop the last field but it dropped them both. If I insert the field in the middle of the spreadsheet....(where I really want it). It drops the last field of the email address. Which I need to send out notifications. I have tried designing a complete new table and importing it, but it continues to do the same thing.
Not sure if my problem is with the spreadsheet or Access. Somehow it is still looking at the old structure when I import even if I create a new table. Not sure what is happening.
Hi, I'm not sure if this is possible, but I've heard you guys really know your stuff.
I have a client who would like to import a list of e-mail addresses, but would like to verify the domain name used in the provided address against a list of domain names pre-populated in a table. Do I need to use Dlookup? Here are some additional details. Thanks in advance!
MAIN_IMPORT_TBL
ID
FNAME
LNAME
E-MAIL
PHONE
DOMAIN_TBL
DOMAIN_ID
DOMAIN_NAME
AP
I have a table with several columns (13).
Every week i want to import a csv-file (250 records) which may or may not have been updated, say 200 are the same as previous week and 50 records are new/updated.
Is there a way to import the csv and add an extra column with who imported all of the new records (based on currentuser)?